Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DataModel decompression

Hi,

I am trying to decompress DataModel file inside a .pbix report. It is written in the header, that the file is compressed using Xpress9 algorithm.  I tried using windows compression API but without any success. Is there any way how to decompress the file?

 

Thanks for help

Martin

Need Help

4 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    6 years ago

    Hi Anonymous ,

    Do you want to extract data from Power BI? You can do it using DAX studio
    https://www.sqlbi.com/tools/dax-studio/


    this article may be helful as well - it explains how connection to local host is managed
    http://biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-2-importing-power-bi...

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello,

      thanks for the tip but i also need informations about measures and how the new columns were created. And the only place where it could be stored is DataModel and decompressing it is the only way how to get it.

      Thanks for the answer

       

      Martin

      • AlexanderK79's avatar
        AlexanderK79
        Advocate III
        6 years ago

        7-zip can do it from the command-line

         

        add the directory where the 7z.exe lives to your PATH environment variable

        change to the directory where you extracted the .pbix file

        issue the command:

        7z x DataMashup -o".\DataMashupDir\" -aoa