Power Query: Power Query Online – Part 11
18 October 2023
Welcome to our Power Query blog. Today, I look at the features on the right-click menu on the diagram view.
In the current series, I am looking at Power Query Online, which I have accessed from Power Apps:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image1-1697477153.png/aa554337ac7f2696f1b95b3a2c008d03.jpg)
Last week, I looked at some data that I have imported from an Azure SQL database:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image2-1697477214.png/e2832345ae0c0d265a0ed009c220a07c.jpg)
I looked at the information about query folding, which is easy to access from the Diagram view:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image3-1697477235.png/3a0bb2209f81d74207d39bbb75245769.jpg)
On the right-click menu, I had the option to ‘View data source query’:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image4-1697477252.png/8fbc548577be8c6e4c0472f19f3412b1.jpg)
This time, I am going to look at how easy it is to analyse the relationships between queries in my current project. I have merged some of my queries:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image5-1697477272.png/63132715d4b439c5d42bddc4b617a7ba.jpg)
Whilst I have tried to give the new merged queries sensible names, I would like to be able to view the dependencies. In Power Query desktop, I am able to do this using ‘View Query Dependencies’ from the View tab (this is showing a different project):
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image6-1697477291.png/0a5ed6eff42bfb376082f709a60e17b2.jpg)
If I click on one query, then any dependent queries, and any queries that this query depends upon, are shown highlighted:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image7-1697477321.png/b2a5d2f38de90a3ccf302898f203b047.jpg)
However, the diagram view in Power Query Online allows me to do much more:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image8-1697477340.png/6441a7eae53a4b86c6d5a5b2a6570006.jpg)
I can access the settings for the diagram view by right-clicking in the pane without selecting a particular query:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image9-1697477358.png/f8ce9a2de4b625edb965ab4ae3d23092.jpg)
Before I move on to the tools I can use to see relationships between queries, let’s look at what else I can do here. The options I have are for all queries, apart from the options to create a new query, which I can do by using ‘Paste’, having copied a query, or by choosing ‘New query’:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image10-1697477380.png/d348d33ef406b651366dd42bbbbe1ad9.jpg)
I can also create a ‘New Parameter’ from here, which takes me to the same ‘Manage Parameters’ dialog that I see in Power Query desktop:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image11-1697477405.png/a61f70d8b6454a1c71571fa4bd31c433.jpg)
I can ‘Expand all queries’ and ‘Collapse all queries’, which is a process I describe in Part 3, along with the mini-map functionality.
Next time, I’ll look at the rest of the options on the menu:
![](http://sumproduct-4634.kxcdn.com/img/containers/main/./image12-1697477440.png/7a49961dc62626026e77477d769c2918.jpg)
Come back next time for more ways to use Power Query!