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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
keviwilso
Frequent Visitor

Document Power BI Reports - Extract Report Metadata

Hi,

 

We need to document the enterprise power bi reports as part of a handover to support. Is there a way to generate / extract the report metadata from the PBIX files ?- i.e. data source connection, Columns Used on the report, Visualisation type and properties, Filters etc. This would also be useful for impact assessments - particuarly if we can derive table.columns used on the report.

 

Any suggestions would be greatly appreciated.

 

Cheers

Kevin 

4 REPLIES 4
v-xjiin-msft
Solution Sage
Solution Sage

Hi @keviwilso,

 

Generally, if you want to extract columns used on report. You can use Power Query Table.ColumnNames() function. 

 

Then about extracting metadata, I think you can refer to following article:

http://radacad.com/exposing-m-code-and-query-metadata-of-power-bi-pbix-file 

 

Thanks,
Xi Jin.

Thanks for the reply Xi Jin.

 

I check out your suggestions below which were useful, however it is not clear on how to use Power Query Table.ColumnNames() function. in this context?

 

I did find this really helpful tool on the the radacad.com website which gives me what I want but unfortunately I cannot export the results - hopefully it will be enhanced to do so.

 

Check out the Power BI Helper tool

 

http://radacad.com/power-bi-helper

 

http://radacad.com/expression-dependency-tree-new-feature-of-power-bi-helper

 

 Cheers

Kevin

Hi Kevin,

 

Did you manage to work out how to do this? Have you checked out Data Vizioner (https://www.datavizioner.com)? Its designed to help you document BI dashboards so it shows many of the things you mentioned in your post.

 

Tim

Hi @keviwilso,

 

Sorry but this is the third party tool. we don't support it and I haven't used it before. I'm afraid that I cannot help you on this part.Smiley Sad

 

Thanks,
Xi Jin.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.