Need help in getting list of datasets that use a particular dataflow

[Anonymous]

Hi all, 

I'm looking to get the list of datasets that uses a particular dataflow. Is there a way to get this list? Do we have an API to get dataflow to datasets mapping? 

[_sfrost · Accepted solution]

@Anonymous 

We do have a REST API for getting list of datasets associated to a dataflow, but that only shows the list of dependant datasets in the same workspace. 

Datasets - Get Dataset To Dataflows Links In Group (Power BI Power BI REST APIs) | Microsoft Docs

AFAIK, we have REST API for only dataset upstream and dataflow upstream as of now and what you are looking for is dataflow downstream and I couldn't find any REST API for downstream dataflow.

Did I answer your questions? Give a thumbs up and accept this as solution.

[v-henryk-mstf]

Hi @Anonymous ,

The function of "view lineage" is to analyze the data flow in the current workspace. If you want to get a list of data streams, first analyze how many datasets there are in capacity, and then list them one by one through rest api. For details, please refer to the document link given by @_sfrost .

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd]

Hey @Anonymous ,

you can see that directly in Power BI Service.

Go to your Workspace and search for your dataflow or filter for dataflows. Then go to the settings and "View linage":

In the linage of your dataflow you see the sources used by your data flow, all the data sets that are using your dataflow, the reports that are using that data sets and the dashboards that use viuals from that reports:

I hope with this you will find the information you need.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[Anonymous]

Thank you for the reply @selimovd . This works if the dataflow and datasets are in the same workspace. In my case, the dataflow is used in datasets that are from different workspaces. In this case, I'm not able to see them in lineage view.