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,
When I rename a table in my tabular model and clicking Refresh in Power BI Desktop, the visual can't find the table and shows an error. Is there a way to update the .pbit to match the updated model?
I did it with this ugly hack.
1) Rename the .pbix file to .zip
2) Unzip it
3) Open the \DiagramLayout file with Notepad++ and replace old table name with new table name. Do the same with the Report\Layout file
4) Zip the folder back and rename to .pbix
5) Try to open the file. If you got message that the file is corrupted, try to open it on another machine. It sould work. This unexplained behavior described here https://community.powerbi.com/t5/Desktop/Programmatically-set-data-colors-by-unzipping-pbix-and-modi...
When you say the "Report\Layout file". Are you referring to the Dataset file, or do you need to .pbix Report file to a .zip and change the \DiagramLayout naming there? (just trying to work out if it needs to be changed in two files, or just the Dataset converted file). Any help greatly appreciated 👍
Did you find a way?
Same issue here 😐
Hello,
This is still an issue. Any help would be appreciated
You may refer to the post below.
Well, seriously: in case of Live Connections (to Power BI datasets/AAS/Tabular),
is it not possible to rename a table (data model) without breaking all the visuals referring to it???
Thanks @v-chuncz-msft, but it refers to Direct Query mode and my .pbit is in Live Connection mode where the Query Editor is not available (Edit Queries button is grayed out)
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |