Visualize Power BI Object Dependences (Dataflows, Reports) in Visual

[LuITS]

Hello,

i have created a Worksapce with lots of dataflows and reports. Sometimes Dataflows use other Dataflows as Input, and Reports of Corse use other Reports aswell.

I want to viusalice the dependences between those objects in a power Bi report. (I don't want to use lineage view in service)

Is it possible to convert a table into a chart shwoing the dependences between Flows.

Table looks like this

Object	Input
Flow1	SourceSystem
Flow2	SourceSystem
Flow3	SourceSystem
Flow4	Flow1
Flow4	Flow2
Report1	Flow4

[Sergii24]

Hi @LuITS, there is an excellent article describing how to achieve a similar result using the "Decomposition tree” visual. Take a look -  How to Create an Organizational Hierarchy in Power BI?🔥 | by Gulce Ekin | Medium

[v-lgarikapat]

Hi  @LuITS ,

Thanks for reaching out to the Microsoft fabric community forum.

@Deku ,

Thanks for your prompt response

@LuITS ,

Thanks for raising this I've reviewed your requirement to visualize dependencies between Dataflows and Reportsspecifically outside of the built-in Lineage View in the Power BI Service.

Using the sample data you provided, I’ve put together a Power BI report that visualizes these dependencies using a Force-Directed Graph (a custom visual available in AppSource). The visual represents each object (e.g., Dataflow, Report, Source) as a node, with arrows showing how they’re connected such as: Which Dataflows consume other Dataflows as input,Which Reports are downstream of those Dataflows

If this post helped resolve your issue, please consider the Accepted Solution. This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
LakshmiNarayana.

[LuITS]

Hallo, tahks for your answer.

The visual is ok but its a little goofy 😄
I would prefer a flow chart with the dependeces. I have a nice result with Sankey Diagram.
The Problem there, which is the same with your visual: I would also like to filter on an object and get the flow of all input objects and their input objects aswell up to the sources.
So i can select a object and see the denpending objects in a clear "Flow like" view.

[v-lgarikapat]

@LuITS ,

Thank you for your response.

@Sergii24 

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

[LuITS]

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.

[v-lgarikapat · Accepted solution]

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

[v-lgarikapat]

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.

[v-lgarikapat]

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.

[Deku]

You can use one of the force directed graph custom visuals, like network graph, network navigator, Deneb etc