Question: how to change query in power pivot?
Answer: In the Power Pivot window, click Home > Connections > Existing Connections.
Select the current database connection and click Edit. ... 
In the Edit Connection dialog box, click Browse to locate another database of the same type but with a different name or location. ... 
Click Save > Close.