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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Mystery
Helper I
Helper I

XML structure

HI,

 

Please let me know if I can extract the underlying files of a .pbix file in an XML format.

 

Regards

7 REPLIES 7
v-jiascu-msft
Employee
Employee

Hi @Mystery,

 

Could you please mark the proper answers as solutions?

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-jiascu-msft
Employee
Employee

Hi @Mystery,

 

There are two ways you can see what's inside. BUT it's definitely a bad idea to make any changes.

1. Unzip the pbix file as a compressed file.

2.1 Install the SQL Server Management Studio. 

2.2 Open the pbix file.

2.3 Open Resource Monitor. Please refer to the snapshot below.

XML-structure

 

 

Best Regards,

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

Thanks.But I cannot see the snapshot.Is it possible to attach it as a picture so that I can get an idea.

 

Regards

Hi @Mystery,

 

How about now? You also can download it from the attachment.XML structure.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

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

No clue as to why, but a PBIX is really just a ZIP file so if you can do it for a ZIP file, you can do it for PBIX.

 

https://stackoverflow.com/questions/13887538/how-to-use-dotnetzip-to-extract-xml-file-from-zip

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Not sure if my question was clear or not.Let me try to be a little more specific.

 

I have the .pbix file in the extracted form and can load it as well inside Power BI.

 

My ask is if I were to look into the backend XML files which make up this .pbix file where are they stored and how can they be accessed.

 

I am trying to access the metadata which is behind the .pbix file.

 

Regards

You best bet is probably the Power BI REST API.

 https://docs.microsoft.com/en-us/rest/api/power-bi/


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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