Extract Data from Power BI(pbix) file using code

[prashantbucha]

Is there a way to extract data rows from tables using the .pbix file?

On researching about the files that comprises the .pbix file, i found that the data is contained in a file named 'DataModel' which is a backup created using Xpress9 Compression. I could not find any documentation/implementation or any other way to decompress a Xpress9 compressed data. Could you please help me on that?

[Stachu]

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...

[AlexanderK79]

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