Diagram View in Power Query showing interconnections across various queries

[avi2]

See image http://www.powerpivotpro.com/wp-content/uploads/2015/08/PQ_DiagramFlow.png - that is a Power Query flow for an actual client project that I built using Power Point and maintain manually as the Queries change. Each box represents a distinct query in Power Query. It would be SUPER useful if Power Query provided an automatic Diagram View, where I could examine how my different queries are connected together and how they flow. I don't think I am the only one building queries like this (modular, inter connected queries). This helps me understand the query structure if I step into the project after a break - or someone else takes over for me. I would imagine others out there have even more complicated structures than the one sample that I shared. An automatic Diagram View would help us all. Also if I peek over to the BI Pros world of SSIS, that has a very visual diagram flow. So I feel a "PQ Diagram View" both makes sense and is much needed.

[nishalit]

This feature is now available starting with the Power BI Desktop September update. Check out the official release announcement for more details: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-september-feature-summary/

[austin6]

Adding some documentation capabilities would be amazing. I'm finally comfortable building complex ETL flows in Power Query, but to Avi's point, the documentation process is very manual and a visual would be great.

[milan_zajc5]

Hi It'll be for me very useful if the graph can be draw also through Measure Path command eig: Struktura = PATH(Struktura[POZ]; Struktura[Nadrejen]). This Path command show me all levels of Bill of Materials and I wants to see the hiearchy of different levels of BOM.. Milan

[milan_zajc5]

I need it so I''l be happy to use it..