Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Everyone,
I have several dashboards published using a Azure SQL DB dataset. There is an upcoming migration where a new dataset of basically the same data will be used in production. This dataset will have differnet table and field names.
Is there any way to convert existing dashboards / visuals over to the new dataset's new table and field names? Or is my only choice to rebuild the dashboard?
Thanks for any information.
Solved! Go to Solution.
@mike12345 , If only the connection is changing that is pretty easy.
refer: https://www.youtube.com/watch?v=59PUFuuCrbY
But as the column name changes - In the advance editor(check last option in the video), you have to also change The column name/s.
In edit query-> Right click on table -> Advance editor -> Change connection details and column name.
Other was is get the new table added to a new pbix. Now carefully replace the initial.
Rename all columns to match the name in power BI. So that dashboard can pick up
@mike12345 , If only the connection is changing that is pretty easy.
refer: https://www.youtube.com/watch?v=59PUFuuCrbY
But as the column name changes - In the advance editor(check last option in the video), you have to also change The column name/s.
In edit query-> Right click on table -> Advance editor -> Change connection details and column name.
Other was is get the new table added to a new pbix. Now carefully replace the initial.
Rename all columns to match the name in power BI. So that dashboard can pick up
You should be able to make new queries to your new database, and copy the first lines from the query from the Advanced Editor and replace the equivalent lines in your existing queries (so all your downstream stuff keeps working). You may have to add rename steps and/or update references between query steps, but you should not have to rebuild.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |