Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |