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.