Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, community.
I'd like to know how to get data flow dependency information from each report in certain workspace.
The detail is as follows.
----------------------------------------------------------
<My requirement>
To get infomtaion about how each report denpends on data flow in certain workspace as list or json format
<Background>
・Our data flow is now used in many report
・But sometimes update of data flow fails for some reason
・So getting dependency information between data flow and report is useful
・Once we get such information, I can notify each user that data flow which is used in your report is not latest becasuse of update error
----------------------------------------------------------
Solved! Go to Solution.
Hi. I think you could use the API to get the datasets using dataflows. The reports are reading datasets, so the datasets are the real deal connecting to dataflow.
This is a post showing how to get orphan datasets as an explanation on how you could do the main steps for getting the datasets that are using dataflows and which are those dataflows: https://blog.ladataweb.com.ar/post/678806355421888512/simplepbi-obtener-dataflows-sin-conexión-a-un
The key request would be: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-dataset-to-dataflows-links-in-group
You can check the datasets conected to dataflows by workspace.
I hope that helps
Happy to help!
@ibarrau
Thank you for your kind support!!
As you mentioned, this will solve my proble, so I'll try it.
I mark your answer as solution.
Best regards
Hi. I think you could use the API to get the datasets using dataflows. The reports are reading datasets, so the datasets are the real deal connecting to dataflow.
This is a post showing how to get orphan datasets as an explanation on how you could do the main steps for getting the datasets that are using dataflows and which are those dataflows: https://blog.ladataweb.com.ar/post/678806355421888512/simplepbi-obtener-dataflows-sin-conexión-a-un
The key request would be: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-dataset-to-dataflows-links-in-group
You can check the datasets conected to dataflows by workspace.
I hope that helps
Happy to help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.