cancel
Showing results for 
Search instead for 
Did you mean: 
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
Microsoft
Microsoft

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
Microsoft
Microsoft

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!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

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!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.