Power Query: Power Query Online – Part 13
1 November 2023
Welcome to our Power Query blog. Today, I am looking at the features on the Diagram view that allow me to analyse relationships.
In the current series, I am looking at Power Query Online, which I have accessed from Power Apps:
Last week, I checked out some of the options on the right-click menu on Diagram view:
This time, I will look at the other information pertaining to related queries. I showed last week that I could choose to highlight related queries as a default:
If I hover over the node in Addresses, I can see the type of relationships from the perspective of Addresses:
I can see ‘Direct dependent queries’, which in this case is Customer full addresses, and ‘Indirect dependent queries’, which in this case is Customers with full addresses, because Customers with full addresses is directly dependent upon Customer full addresses.
The default highlighting is from the perspective query with the node filled; however, I do not need to select a different node to see the relationships from another query’s perspective – I can just hover over the appropriate node.
If I hover over the left-hand node on Customer full addresses, I can see which queries are referenced by Customer full addresses. In this case, there are only ‘Direct referenced queries’ since Addresses and Customer_Addresses came from the data source. I can only see highlighting from the perspective of the query with the filled node, and only one query may have a filled node.
From the perspective of Customers with full addresses, there are ‘Direct referenced queries’ which were merged to create this query, and also ‘Indirect reference queries’ which were used to create the queries that are merged to create this query.
Note that selecting a node will change the perspective of the query highlighting, but not change the query selected. The highlighted outline of Addresses indicates that it is the selected query, and this is why the steps from that query appear in the ‘Query settings’ pane.
I can also choose another query from a reference or dependency list to change both to the perspective of that query, and also select that query. Below, I have chosen Customers with full addresses from the ‘Indirect dependent queries’ list for Customer_Addresses:
Finally, I can also toggle query highlighting to on or off using the icon currently visible on the selected query, and also on the query with the node selected:
If the highlighting icon is currently highlighted, the relationship highlighting is turned off. If it is not already highlighted from the perspective of the current query, it is turned on for that query. Although it is not shown by default, this icon is available when I hover over any query with relationships (in the next image I am hovering over Customers with addresses):
It is not possible for me to highlight Products or Product Categories in this way, as no relationships exist for either of them.
This brings my current series on Power Query Online to a close. I hope it will not be too long before the same interface is available in Power Query Desktop. In the meantime, I will revisit some Power Query Desktop topics that have been improved since I last covered them…
Come back next time for more ways to use Power Query!