Please note javascript is required for full website functionality.


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:

Last week, I looked at some data that I have imported from an Azure SQL database:

I looked at the information about query folding, which is easy to access from the Diagram view:

On the right-click menu, I had the option to ‘View data source query’:

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:

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):

If I click on one query, then any dependent queries, and any queries that this query depends upon, are shown highlighted:

However, the diagram view in Power Query Online allows me to do much more:

I can access the settings for the diagram view by right-clicking in the pane without selecting a particular query:

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’:

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:

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:

Come back next time for more ways to use Power Query!