Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
michal089
Frequent Visitor

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." . Have anyone tried to decompress the file ? What tools do I need to do so?

 

Any help would be much appreciated.

Michal

8 REPLIES 8
Anonymous
Not applicable

Export the .PBIX to .PBIT from within Power BI Desktop, then rename the .PBIT to zip, extract, and the DataModelSchema is readable

SWEET!!! I've since moved on and am getting this through either SQL Server Management Studio or through ALMToolkit. But this is great too. I wonder if I can automate PBIX->PBIT->DataModelSchema.json with PowerShell too. Much appreciated!

MichaelLowden
Frequent Visitor

So far, the best approach I've found is to manually use the tool "ALM Toolkit". Open your desktop file in PBI Desktop, and then open ALM Toolkit. You can choose the desktop file from here as "source", and the online version as "target". Compare differences just to run the app. Then, even if everything is identical, you can export to XLSX the full definition of the PBIX. Here you'll find JSON formatted cells with things like your formulas and column names and the works. This will become a weekly effort for me to re-run any recently modified PBIX dataset sources, and generate new XLSX files that are then my source files for another process to consolidate and report out my data dictionary. Being all of this is running via APIs to PowerBI Desktop/Online I have to also imagine I could write something directly to the online service to pull the same JSON data dictionary. However, I haven't found the correct API yet.

captnchris
New Member

The .pbix is a PkZip format that can be unzipped with pkzip, winrar, 7z...

Open a .pbix with text editor a you'll see it starts with a "PK<etx><eot>..."

The inner files are compressed in different format ... that I am also looking on how to ... 😊

 

Anonymous
Not applicable

I was just about to do this but didn't want to bother if it was a dead end.

 

Did you succeed?

v-cherch-msft
Microsoft Employee
Microsoft Employee

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Anonymous
Not applicable

I find that 7z won't extract it for me. 

Canot open the file as archive, unfortunately.

 

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.