Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

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? 

1 ACCEPTED SOLUTION
_sfrost
Solution Specialist
Solution Specialist

@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.

View solution in original post

4 REPLIES 4
_sfrost
Solution Specialist
Solution Specialist

@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.

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
Super User
Super User

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":

19_1.png

 

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:

19.png

 

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
 
Anonymous
Not applicable

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. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.