Check which reports are using a dataflow

[PANDAmonium]

Is there a way to check which reports are using a dataflow? I planned on deleting a couple old dataflows, but wanted to verify that there aren't any reports currently using them. Thanks!

[ibarrau · Accepted solution]

Hi. I think you have two alternatives. The first one is going one by one to the workspaces and activate the linage view. That way you can check the flow of data from sources to reports.

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-data-lineage

The second and more complex option would be building a script with the Power Bi Rest API that should first get all the datasets in the tenant and then for each one of those check its sources.

Hope that helps,

[PANDAmonium · Accepted solution]

After getting sidetracked for *checks date* 1 year, 9 months, and 7 days... I finally got around to building this thing out. Ended up finding my own post as a top Google result and it looks like people were still having issues tieing the Dataset Id to the Dataflow Id via the REST API, but it looks like Microsoft Power BI updated some things so here is an updated solution:

They added a upstream datasources to the view lineage option, but if you insist on using the REST API, they've added a REST call to get all the Dataset and Dataflow Id links for a workspace.

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-dataset-to-dataflows-links-in...

The solution uses the REST API to get the group Ids then iterates through that to get the dataset Ids then again to get the dataset and dataflow Id links then again for the dataflow info all within a dataflow that are brought into tracking reports.

Sorry to necro this post; hope it helps someone to try it rather than give up since I almost did after reading through the dated replies.

[timhamaguchi]

hey there - how do you access the upstream datasources in the view lineage? I don't any option to do this. thanks!

[ibarrau · Accepted solution]

Hi. I think you have two alternatives. The first one is going one by one to the workspaces and activate the linage view. That way you can check the flow of data from sources to reports.

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-data-lineage

The second and more complex option would be building a script with the Power Bi Rest API that should first get all the datasets in the tenant and then for each one of those check its sources.

Hope that helps,

[NatachaPN]

Hi! Following your suggestion, I am developing a process to detect orphaned dataflows in my environment, using API REST in PowerAutomate.  

I have a Dataset conected to a couple of Dataflows plus a list on Sharepoint.

When I check the sources of this Dataset ID, with:

GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/datasources

I receive a response that contains only two datasources 

I have test with others examples, and are the same. The responses has datasourceId that I cannot find as ID of my dataflows. I wonder if I should run other API using the datasourceId in a loop.

Could you suggest me some improvement?

[rjhale]

@NatachaPN I'm struggling with the same thing right now.  I'm finding the dataset ids without any problem using the datasources endpoint, but those appear to be unique to the dataset.  Did you ever find a way to use information to correlate the dataset to a particular dataflow?  

[NatachaPN]

unfortunately, not yet

[PANDAmonium]

Thanks! Yeah, I was hoping there would be a lineage option where it shows upsteam instead of just downstream before going the Rest API route. There's also a third option which is to export the json, delete it, and wait for complaints or refresh errors to come in... that'll be our plan b, lol.

[edseitzinger]

You don't need to delete the dataflow, simply change the names of the tables that are exposed from the Dataflow, stuff will still break when irs looking for "Dataset1" and you rename it to "Dataset_1".