Power BI Dataflow – New Diagram View
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.
- Create a dataflow
- Set up dataflow refresh
- Endorsement
- Diagram View
- Refresh History
- Create dataflow from Export json file
- Incremental Refresh
YouTube Version
Displaying Diagram View
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.
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.
Query Steps Preview
If you hover your mouse pointer over the step counter, it will display a list of the query steps.
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.
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.
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.
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.
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.
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.
