Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone !
I currently work at a company where I design PowerBI reports for our clients. Having a large number of clients, we would like to automate the process of creating and maintaining the reports with code.
In idea, we would like to be able to get the code for a "master report" so that we can modify it directly with code without having to open PowerBI. This would not only automate the process of creating a report by duplicating the master report and making all the necessary modifications with code, but also its maintenance. Indeed, when we make a change in a report, we must currently do it manually for all other clients which is very time consuming.
The structure of the reports is identical for each of the clients except for a few details:
I have done a lot of research on how to do this, I have done some tests but I can't really find a solution that works. Here are the tracks I explored:
Do you know if one of the tracks I mentioned can achieve what I want to do? Is there any other way to automate the creation and maintenance of reports ? Do I miss something in my way of thinking ?
Thank you in advance for your advice!
Melvin
Solved! Go to Solution.
Hi!
1. Opened the Layout file in Notepad++
2. Saved the file in other location as .txt
3. Made changes in Layout file
4. Saved my changes and closed the Layout.txt file
5. Removed the extension .txt from the file in the File Explorer.
6. Copied the file and pasted it in the Report folder in the report zip file
7. Changed the extension of the report file from .zip to .pbix
Regards
Fredrik
Hello Melvin!
I have used your third option with success. This is the steps I used to avoid the file getting corrupted.
1. Rename to .zip
2. Delete the SecurityBindings file
3. Remove <Override PartName="/SecurityBindings" ContentType="" /> in the [Content_Types].xml file
4. Open the file Layout and do my changes in Notepas ++
5. Rename the file to .pbix again
I do not extract the zip file at any time.
Regards
Fredrik
Hello FredrikJ !
First of all, thank you for your reply. I have tried what you said, however it seems that I am not able to save the changes I made in the Layout file when I open it without decompressing the whole folder. I can't overwrite the file while i was able to dot it when the whole folder was decrompressed.
How did you do it exactly ?
Best regards,
Melvin
Hi!
1. Opened the Layout file in Notepad++
2. Saved the file in other location as .txt
3. Made changes in Layout file
4. Saved my changes and closed the Layout.txt file
5. Removed the extension .txt from the file in the File Explorer.
6. Copied the file and pasted it in the Report folder in the report zip file
7. Changed the extension of the report file from .zip to .pbix
Regards
Fredrik
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
17 | |
11 | |
5 | |
4 | |
3 |