How can we improve Power BI?

Diagram View in Power Query showing interconnections across various queries

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.

47 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Avi Singh shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    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

  • Austin Senseman commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.