Two queries, one table. How to switch between the two

[Memphis_JW]

I have a workbook with one table with the data source coming from a query (DataPull1). I want to know how to switch and run a second query and replace the data with data from the newly activated one (DataPull2).

I do not want a second table unless it is placed in the exact same location.

I did it accidently once but, cant seem to find out how to do it intentionally.

(Note: If possible, I plan to record the steps and do the steps and  record a macro to switch between 1 and 2 so that I can run either at the click of a button)

[v-stephen-msft · Accepted solution]

Hi @Memphis_JW ,

You can create a parameter for this for changing data source dynamically. Please kindly refer to

Change the Data Source dynamically in Power BI using Parameters - SqlSkull

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.