Forum Discussion

LuITS's avatar
LuITS
Icon for Helper II rankHelper II
1 year ago
Solved

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

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

ObjectInput
Flow1SourceSystem
Flow2SourceSystem
Flow3SourceSystem

Flow4

Flow1

Flow4

Flow2

Report1

Flow4

 

Need Help
Show and Tell
  • v-lgarikapat's avatar
    v-lgarikapat
    1 year ago

    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

9 Replies

  • Deku's avatar
    Deku
    Icon for Super User rankSuper User
    1 year ago

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

  • v-lgarikapat's avatar
    v-lgarikapat
    Icon for Community Support rankCommunity Support
    1 year ago

    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    .

     

    • v-lgarikapat's avatar
      v-lgarikapat
      Icon for Community Support rankCommunity Support
      1 year ago

      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.

    • LuITS's avatar
      LuITS
      Icon for Helper II rankHelper II
      1 year ago

      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's avatar
        v-lgarikapat
        Icon for Community Support rankCommunity Support
        1 year ago

        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