Lineage that includes data source and table

Question

Hi, we would like to gather usage statistics on what database tables/views are being used in which Power BI reports/datasets. The lineage diagram only goes down to dataset level. Usage statistics only captures report views. Using the API&nbsp;Get Datasources In Group, we can get the connection string but not the table name. Are there any other options? Thanks in advance!

collinq · Answer

HI&nbsp;Anonymous&nbsp;,
&nbsp;
I think yo uare looking for a third party tool for this - and I am not sure that any are Service related....they may be, I am just not sure....so you may have to do this on your Desktop.&nbsp; Here is probably the one you are looking for:
Power BI Field Finder -
&nbsp;

anonymous · Answer

Thanks for linking the tool - it needs to import pbix files one by one. We're hoping to collect statistics on datasets across multiple workspaces in our organization 😅.

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Try&nbsp;Push Datasets - Datasets GetTables
https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets/datasets_gettables&nbsp;Or Push Datasets - Datasets GetTablesInGroup
https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets/datasets_gettablesingroup&nbsp;
&nbsp;
Best Regards,
Jay

anonymous · Answer

Thanks Jay. Unfortunately, these APIs are for push datasets only (like realtime streaming), not regular datasets.

Forum Discussion

Lineage that includes data source and table

4 Replies

Related content

Understanding Lineage View

Lineage in Purview

Dataflow Lineage

lineage and more

retrieve source table-level lineage for Power BI reports