Forum Discussion
Visualize Power BI Object Dependences (Dataflows, Reports) in Visual
Hi LuITS ,
Thanks again for the feedback I completely understand what you're aiming for: a clear flowchart that shows all input dependencies recursively up to the source when selecting any given object.
Your right visuals like the Force-Directed Graph or Sankey Diagram alone don’t natively support tracing multiple dependency levels unless we reshape the data model.
To solve this, I implemented a solution that
1.Recursively expands all inputs for each object (not just direct links)
2.Converts that into a structure usable in Sankey or similar visuals
3.Let’s you filter on a single object and see all its upstream dependencies in one clear flow
So now, for example, if you select Report1, the visual shows not just Flow4, but also Flow1, Flow2, and SourceSyst all the way back to the source.
This is done by preprocessing the dependency table using Power Query to generate a complete flattened lineage, which makes the visualization clean and accurate.
For reference
Solved: Recursive Function in Power Query - Microsoft Fabric Community
Solved: Project dependency visual? - Microsoft Fabric Community
Solved: Multi-level sankey query - creating supporting vis... - Microsoft Fabric Community
If you are still encountering any challenges, we would be happy to assist you further
BestRegards,
Lakshmi Narayana
LuITS ,
Thank you for your response.
Thanks for your prompt response
LuITS Could you please try the solution suggested by Sergii24 ? It includes a step-by-step approach that may help resolve the issue. Kindly let us know how it works for you.
If you’re still facing any challenges, please don’t hesitate to reach out we’ll be happy to assist you further.
Looking forward to your response.
Best regards,
LakshmiNarayana
Hi, it seems like this solution only works if there is no Duplcates. Like an Employee who has multiple Managers. Which is the case in my example, a Flow can have multiple inputs.
Hi LuITS ,
Thanks again for the feedback I completely understand what you're aiming for: a clear flowchart that shows all input dependencies recursively up to the source when selecting any given object.
Your right visuals like the Force-Directed Graph or Sankey Diagram alone don’t natively support tracing multiple dependency levels unless we reshape the data model.
To solve this, I implemented a solution that
1.Recursively expands all inputs for each object (not just direct links)
2.Converts that into a structure usable in Sankey or similar visuals
3.Let’s you filter on a single object and see all its upstream dependencies in one clear flow
So now, for example, if you select Report1, the visual shows not just Flow4, but also Flow1, Flow2, and SourceSyst all the way back to the source.
This is done by preprocessing the dependency table using Power Query to generate a complete flattened lineage, which makes the visualization clean and accurate.
For reference
Solved: Recursive Function in Power Query - Microsoft Fabric Community
Solved: Project dependency visual? - Microsoft Fabric Community
Solved: Multi-level sankey query - creating supporting vis... - Microsoft Fabric Community
If you are still encountering any challenges, we would be happy to assist you further
BestRegards,
Lakshmi Narayana
Hi LuITS ,
If your issue has been resolved, please consider marking the most helpful reply as the accepted solution. This helps other community members who may encounter the same issue to find answers more efficiently.
If you're still facing challenges, feel free to let us know we’ll be glad to assist you further.
Looking forward to your response.
Best regards,
LakshmiNarayana.