Forum Discussion

ronnoc's avatar
ronnoc
Icon for Advocate II rankAdvocate II
9 years ago
Solved

Programmatically set data colors by unzipping .pbix and modifying Layout.file

Hi there, big thanks to everyone in the community for all the help so far.   At the moment I am trying to tackle the problem of setting visual fields of my reports for example data colors in visual...
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    ronnoc

     

    If I open the pbix file with 7-Zip, open the Layout file with Notepad++, change the color and save the Layout file to local drive then replace the original one in 7-Zip, I will got the same error message as you when open the changed pbix file.

     

    But if I copy this changed pbix file to another machine which installs the same version of Power BI Desktop, the file can be opened properly and the color has changed properly.

     

    So you can try to modify the layout file in one machine, but do not open this file with the same machine. I’m not sure why but you can have a try. For how to use 7-Zip and Notepad++, please refer to this article.

     

     

    Best Regards,

    Herbert

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Has anyone been able to go in and modify the datamashup file? I was wanting to replicate all the fomulas in the DataMashup\Formulas\Section1.m into a new pbix file, but keep getting the corrupt message 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous Any luck with editing the DataMashup file, I am trying to do the same but keep getting corrupt error.