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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Krcmajster
Helper IV
Helper IV

Get visual metadata with PowerShell or REST API

I don't know if this is the right place to ask this. 
I want to automate some things for our team. I started to play with PowerShell and I wanted to use it to do what I have planned. 
I want to get visual metadata like name, fields or measures used, description, etc. But from what I see Power BI cmdlets (and REST API) don't go further from Power BI report (actually tile, but we do not have those). 
Does anyone know how I can pull this via script, it does not need to be PowerShell, JS or Pyhton are also acceptable. 

3 REPLIES 3
lbendlin
Super User
Super User

Short answer : You can't, this meta data is not exposed.

 

Long answer:  If you have access to the PBIX file you can extract the meta data from there. PBIX files are archives and you can view them with your favorite viewer or extract them with Powershell.

Anonymous
Not applicable

Hi , I have a similar Requirement to get XML of the reports/dashboards. I tried to convert pbix files to pbit and then zip and then extract. but I didnt get the XML file from anywhere which gives me the Report details. Any suggestions here ?

 

Also JSON file will also work if MS has exposed this.

Wait for the TMDL implementation. Download the June 2023 Power BI Desktop, save as .PBIP - into a git repository

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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