Forum Discussion
Modifying the Layout file that is embedded in a pbix file
- Anonymous5 years ago
I was struggling with this issue recently, and my solution is the following:
- Change the extension from ".pbix" to ".zip"
- Do not unzip the ".zip" file during this process
- Extract the "Layout" file from the "Report" folder in the ".zip" file
- Open the "Layout" file with Notepad++. (VERY IMPORTANT)
- Make your modifications in the Layout file
- Substitute the old "Layout" file with the new one
- Delete "SecurityBindings" file in the ".zip" file
- In the [Contents_type].xml delete the following text:
"<Override PartName="/SecurityBindings" ContentType="" />"
- Change the extension from ".zip to ".pbix"
- The file will open without breaks
Hope it helps!
dia,
I want to change the displayNames and the textRuns. Essentially I want to replace these by translations of the English into other languages and do this programatically. I can do this, but then when I try to change the .zip file back to a .pbix file I can no longer open it in Power BI. I get a message that the file is corrupted. This happens with only the smallest change. For example if I only change the first of the displayNames values, which is the name of the Power BI page, from "Page 1" to "Page 2". Is there any way to make such a change without getting the corrupted file message? If I make no change at all I can get back to the .pbix file and have it display again with no problem.
Still looking for answers on this. Anybody?