Forum Discussion
How to decompress DataModel from PBIX file.
Hi, Recently I have played around with .pbix files. I've tried to unzip the file and open DataModel. The main obstacle is that I can only read "This backup was created using XPress9 compression."...
Hi michal089
It seems there is no better tool to decompress the file. Below are some articles about the file. You may connect the model from Excel and SSMS: Connect to Power BI Desktop Model from Excel and SSMS.
http://www.sqlgene.com/2018/01/30/power-bi-desktop-files-are-smaller-now/
https://www.fourmoo.com/2017/05/02/what-makes-up-a-power-bi-desktop-pbix-file/
Regards,
Cherie
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
I find that 7z won't extract it for me.
Canot open the file as archive, unfortunately.
