Forum Discussion
Extract Data from Power BI(pbix) file using code
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?
2 Replies
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-data-to-excel-directly/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
