Forum Discussion
Check which reports are using a dataflow
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,
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.
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.
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,
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.
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".
