Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.