Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 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 witho...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
7 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
    7 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
      Icon for Advocate III rankAdvocate 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

      • user5479439's avatar
        user5479439
        New Member
        5 years ago

        Have you tried this with a PBIX file having a "DataModel" file inside, not a "DataMashup"? 7-zip does not seem to be able to decompress "DataModel" files from PBIX files.