Please Star PowerBI Scanner if you like it.

PowerBI Scanner

Build a power bi report to understand and monitor the artefact in your report.

• How many data sources we have?
• is it web content(URL) , sql database (Server, Database, Table/View), DocumentDB (URL, Collection, Entity)
• How many datasets have been used in a report?
• What are the power query scripts?
• Do we have DAX measure? what are the DAX scripts?

Methodology

PowerBI is using DataModelSchema to store the metadata, thus, we could read and report the metadata

• Measures can be found in: model.tables.measures
• Columns can be found in: model.tables.columns
• Calculated Columns can be found in: model.tables.columns

Compatibility

Compatible with May 2021 Power BI Desktop

Demo

If you would like to have further changes or more support, please email me.

Here is a sample report for your reference.

https://app.powerbi.com/view?r=eyJrIjoiNjI3NDFhM2EtZDQ0MS00Y2FiLWE1ZTItYzY5OThmNjhmMjY5IiwidCI6IjcxY2ZiZjg4LTE2ZWItNGVjMC05M2E2LTYzYzNkMWRlMWY0MyJ9