Forum Discussion
Modifying the Layout file that is embedded in a pbix file
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!
I would recommend you follow the instructions in the blog below to change layout.
https://powerbi.tips/2018/01/introducing-layouts/
Regards,
Lydia
Thanks, Lydia. But I am not asking about changing the visual layout of a page. I am asking about changing a particular file named "Layout" that is exposed when you deconsturuct a PBIX file. This file contains the formatting information for the page and the text that the designer has entered into it. To get to this file, you do the following to a PBIX file:
1. Changed the extension from ".pbix' to ".zip".
2. Open the zip file. You will see several folders. Go into the Report folder, and you will see the Layout file.
--Joey
maceyak,
What property do you change in the Layout file? There is no official articles stating that what we can do or can't do in the Layout file.
Regards,
Lydiadia,
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?