March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi:
In Power BI Desktop, I have visualizations that display the data perfectly.
I want to use this same dashboard but "point" it to a different database.
This "different" database contains the same tables as the original -- just different data within those tables.
How do I conduct this "pointing"?
Thanks!
John
Solved! Go to Solution.
Hi @jellis1971 , @lbendlin thank you for your prompt reply!
As lbendlin said, you need to have another database in the same server and have the right permissions on it.
Then based on your needs, we could save the existing pbix file as a new file with a different filename, such as file2:
Then open the copied file, switch to Data Source Settings and change the data source to another database:
After making changes, please remember to apply changes to see the results.
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @jellis1971 , @lbendlin thank you for your prompt reply!
As lbendlin said, you need to have another database in the same server and have the right permissions on it.
Then based on your needs, we could save the existing pbix file as a new file with a different filename, such as file2:
Then open the copied file, switch to Data Source Settings and change the data source to another database:
After making changes, please remember to apply changes to see the results.
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is that database on the same server? Do you have read permissions for both databases?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
133 | |
90 | |
88 | |
64 | |
58 |
User | Count |
---|---|
203 | |
141 | |
107 | |
73 | |
70 |