Power BI Dataflow – New Diagram View

Last modified date

In November 2020 a new diagram view was introduced to the online Power Query editor. The new feature produces a brilliant diagram of how the queries and parameters relate within the dataflow.

Dataflow Series

This post is part of a series on dataflows.

YouTube Version

Link to YouTube

Displaying Diagram View

View ribbon

When editing your dataflow, click on the View ribbon tab and select Diagram View. The diagram view will appear between the ribbon and the formula bar.

Diagram view displayed

Object Types Shown in Diagram View

The entities with a blue border are loaded entities, i.e. listed when connecting and the entities with a grey border are not loaded, so they refresh but are not exposed to the report builder. Parameters and functions have a relevant symbols in the top left and a grey border.

boxes in diagram

Query Steps Preview

If you hover your mouse pointer over the step counter, it will display a list of the query steps.

step preview in diagram view

Expanding Display View boxes

In the top right corner of each query and function box there is a double-headed arrow button. Click this button to expand the query and show all the steps. The button is a toggle to switch between collapsed and expanded views.

expand display view boxes using toggle

If multiple queries are expanded, you can collapse all query boxes by using the toolbar in the bottom right of the canvas. It has collapse all and expand all buttons.

canvas buttons

Displaying Step Names

By default an expanded query displays step labels, i.e. the name of the action being applied. You can display the names of the steps by clicking on arrow below Diagram view button and selecting Show step names.

displaying step names

Related Queries

Related queries can be highlighted using the model diagram button in the top right of the query box. It will highlight all related objects blue or grey based on their borders. In a complex dataflow this can be useful to understand the complexities.

highlighting related queries.

Adding Steps

When a query is selected and expanded it displays a plus sign. Clicking on the plus button displays a list of possible steps to add, it will be based on the column you have selected. There is a search box to assist in finding the right step.

adding steps

Clicking on the three dots in the top right hand corner offer multiple query steps to add to the query plus some other options.

Conclusion

Diagram view is a great addition to the online dataflow editor. Diagrams are a great way to explain a structure and this should help explain transforms within a dataflow. Personally I doubt I will be using the plus button to add steps, but then I am not the target audience.

Over 20 year experience at being passionate about training, solving problems and loving a new challenge especially in the Microsoft's Power Platform suite.