Power BI REST API - Datasets, Dataflows, and Data sources

[peterg0417]

I'm working on a Power BI Usage dashboard, and 1 feature that we'd like to include is to see what data sources a report uses. To get that I needed to get "data source" data from the API.

This worked for semantic models (fka data sets). I can join the data set and data source data, and see whether it's using SQL Server, SharePoint, or a Dataflow (important!)

This also worked for Dataflows. I can see if a Dataflow uses SharePoint, SQL, another Dataflow, etc.

The problem arises when I try to link my dataset -> Dataflow data, on dataset.datasourceID = Dataflow.dataflowID. I get 0 matches. I can see that a dataset uses a dataflow, but the sourceID column doesn't seem to contain the ID of which dataflow is the source.

The reason for trying to connect the 2 is so I can map this out (as an example):

PBI Report ---> PBI Semantic Model/Dataset ---> Dataflow ---> SQL

But because I can't seem to link Dataset ---> Dataflow, at least not with the columns provided.

Does anyone have experience with this? Is there a bridge table that I need to query in the API?

Thanks,

[lbendlin]

Have you considered using Purview or Collibra?

[peterg0417]

Not sure I follow. Would I be able to grab usage, and PBI tenant data automatically using Collibra or Purview like I'm currently doing through ADF?

[lbendlin]

Usage and Usage are different things...

For actual usage you use the tenant audit logs.

For inventory and DLP you use Purview or Collibra