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

Published Jul 28 2022 05:51 AM 7,382 Views
Microsoft

Another achievement unlocked in Excel for the web: We have added Group operations to the Queries Pane! This will allow you to better sort your queries and perform various operations on query groups.

 

Getting started

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

 

AnimationBLOGGROUPS.gif

 

 

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

jokahati_0-1659012105773.png

 

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

    jokahati_1-1659012105778.png

  • You will see the new group was created:

    jokahati_2-1659012105778.png

     

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

    jokahati_3-1659012105783.png

  • 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

    jokahati_4-1659012105784.png

     

Note: Refresh will work for supported data sources only.
See this support article for more information on Power Query data sources in Excel versions.

 

 

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

jokahati_5-1659012105785.png

 

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

jokahati_6-1659012105786.png

 

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

jokahati_7-1659012105787.png

 

 

Delete a group

 

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

jokahati_8-1659012105788.png

 

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…

    jokahati_9-1659012105788.png

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

jokahati_10-1659012105790.png



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

jokahati_11-1659012105793.png

 

 

Edit a group’s properties

 

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

jokahati_12-1659012105795.png

 

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

 

jokahati_13-1659012105796.png

 

 

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

    jokahati_14-1659012105797.png

     

 

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!

 

 

What’s next?

Future plans include Query operations, among other plans, towards releasing the full Power Query Editor experience to Excel for the Web.

 

 

Feedback

We hope you like this new addition to Excel and we’d love to hear what you think about it!

Let us know by using the Feedback button in the top right corner in Excel - add #PowerQuery in your feedback so that we can find it easily.

 

Want to know more about Excel for the web? See What's new in Excel for the web and subscribe to our Excel Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Twitter.

 

5 Comments
Co-Authors
Version history
Last update:
‎Aug 11 2022 01:36 AM
Updated by: