Creating Groups for Power Queries in Excel

Put some order in your queries

Once you start to use Power Query you may find yourself with quite a few queries in the one file. To make it easier to control them you can use groups to keep similar queries together.

As you can see in the image below this budget file has a lot of queries and a few groups.

I have grouped queries together to make the processes easier to follow.

To add a new group right click a query and select New Group. Give it a name and click OK.

You can then hide queries by collapsing the group names.

 

Using groups tidies up the query task pane and makes it slightly less overwhelming.

Note the Other Queries group is a system generated group which you can’t edit or delete.

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.