New in Excel for the web: Power Query Group operations are now available

8/17/2022

This new functionality is available on Excel for the Web to all Office 365 Subscribers with Business or Enterprise plans.

Performing Power Query Group operations

You can now perform various operations on Power Query groups to better organize your queries and easily consume the data on the queries pane.

 To begin, open the Queries Pane, select the Data tab > then choose Queries

 

Create a new group

• Select the top-level button > then choose New group

• Give the new group a name. If you like, you can also enter a description. When you are done, choose Save.

• You will see the new group was created:

Note: Until you move queries into groups, all queries will be listed under the “Other queries” group

 

Expand/Collapse all groups

• Select the top-level button > then choose Expand all/Collapse all

• You will see the result of the respective action in the Queries pane.

Note: You can Expand or Collapse any group by using the arrow next to the group name

 

Refresh a group

• If the group contains queries, you can refresh all of them at once, the same way you can refresh individual queries 
• To do this, select the action menu button > then choose Refresh

Note: Refresh will work for supported data sources only.

 

Ungroup the queries within a group

• If you want to reorganize your queries and take them out of the group, you can use this operation 
• To do this, select the action menu button > then choose Ungroup

Note: This action will only delete the group, not the queries in this group

 

Rename a group

• To do this, select the action menu button > then choose Rename

• Enter the new name, then press anywhere to save changes

 

Delete a group

• To do this, select the action menu button > then choose Delete group

Note: At this stage, delete is supported for empty groups only. We are working on adding support for deleting groups that include queries.

 

Move a query or group into another group

• To do this, select the action menu button > then choose Move to group…

• Select the item you want to move it to > then select Save

 

Move a group to the top level

• If a group is nested within 1 or more groups, you can quickly move it to the top level 
• To do this, select the action menu button > then choose Move to top level

 

Edit a group’s properties

• To do this, select the action menu button > then choose Properties

• You can use this to rename the group or change its description. When you are done, select Save.

• You will be able to see the group description by hovering over it

 

That’s all folks!

We’re continuing to work on enabling query operations, as well as with other features. These are just some of the latest improvements on our journey to enable full Power Query capabilities in Excel for the Web, with many more coming soon!

 

Source: techcommunity.microsoft.com