Skip to main content

Power BI

Completed

Diagram View in Power Query showing interconnections across various queries

Vote (47) Share
Avi Singh's profile image

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)
Avi Singh's profile image Profile Picture

25ef73ac 7c13-40f1-95ef-f87ec75b94c2 on 05 Jul 2020 22:26:48

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

Avi Singh's profile image Profile Picture

25ef73ac 7c13-40f1-95ef-f87ec75b94c2 on 05 Jul 2020 22:26:24

RE: Diagram View in Power Query showing interconnections across various queries

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

Avi Singh's profile image Profile Picture

11714d96 e626-4b4c-bfda-80a353201408 on 05 Jul 2020 22:03:52

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.