Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
User | Count |
---|---|
9 | |
8 | |
6 | |
6 | |
6 |