How to read PBIX file - DataMashup & datamodel

[pratheeban]

Hi All,

I want to read to read the metadata of the Power BI reports from the PBIX file... Once I unzip the file, I could see a lot of files. I am able to read the Layout file which is in JSON format.

But I could not read the Data Mashup and Data Model file... Please help me understand how to read the metadata from the files

Thanks

[bcherupally]

Actually, the PBIX file is an export file and when you open the saved PBIX file it directly displays the data which is exported. Means, it doesn't query the data source unless you hit the "Refresh" button. So, the data saved in the PBIX will be part of the "DataModel" file in highly compressed format which you can't read. On the other hand, you can just read the DataMashup file partially using the 7zip tool, which allows you to atleast read the contents of the mashup query (Section1.m).

Thanks,

Bhargav

[v-juanli-msft]

Hi @pratheeban

Download 7-zip to your computer.

Right-click on the pbix file, select 7-zip->open archive, you can open the window below.

Best Regards

Maggie