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)
Solved! Go to 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.
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.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!