Forum Discussion

ronnoc's avatar
ronnoc
Advocate 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
9 years ago

Has anyone recently managed  to use this "workaround"?  I've followed the instruction, but anyway get error message about corrupted report.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    I have that same problem...no luck so far :(

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    I have that same problem...no luck so far :(

  • melwakil's avatar
    melwakil
    Frequent Visitor
    8 years ago

    I got the same error message about corrupted report !

  • kkalyanthaya's avatar
    kkalyanthaya
    Microsoft Employee
    8 years ago

    Has anyone found a solution to this ?