Power BI
CompletedDiagram View in Power Query showing interconnections across various queries
Avi Singh on 25 Aug 2015 03:25:13
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.
Administrator on 15 Oct 2016 01:19:00
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/
- Comments (3)
RE: Diagram View in Power Query showing interconnections across various queries
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
RE: Diagram View in Power Query showing interconnections across various queries
I need it so I''l be happy to use it..
RE: Diagram View in Power Query showing interconnections across various queries
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.