How to get source table level lineage of a power BI report in an automated way?

Question

Hello,

I’m looking for an automated way to retrieve source table-level lineage for Power BI reports.

Our organization has hundreds of reports, and manually downloading each one to check the source queries or objects is not feasible.

For example:

Power BI Table Name: Sales Data

Source Table Name: Schema: XXMS, Table: DWC_sales_data

Is there a way to automate this process using Power BI REST API, Metadata Scanning, or any other method? Any guidance or best practices would be greatly appreciated!

Thank you.

Answer 1

Microsoft Q&A(en-us) does not support Fabric.
Please ask your question in the community below.
Fabric Community
　├ Power BI
　├ Data Engineering
　├ Data Warehouse
　├ Data Science
　├ Data Factory
　├ Real-Time Intelligence
　├ Databases
　└ Fabric platform