Tuesday, May 10, 2022

New in Excel for the web: Power Query Refresh is now generally available for selected data sources

We’ve reached yet another milestone in Excel for the web: Power Query Refresh is now generally available for queries sourcing data from the current workbook and anonymous OData feeds. 


By far one of the most popular requests we have received from Excel users, Power Query Refresh marks another milestone in our journey to bring full Power Query capabilities to Excel for the web.


Additional capabilities:


  • Queries refresh in the background so you can continue working on the grid
  • Queries refresh asynchronously, instead of one-by-one, enabling faster refresh


Getting started

This new functionality is available to all users on Excel for the web. 
See this support article for more information on Power Query data sources in Excel versions.





Refreshing Power Query queries

You can now refresh the Power Query queries in your workbook that source data from the current workbook ("From Table/Range") and anonymous OData feeds. In addition, you can also start with a blank query, write some M code, and refresh it. 

The refresh happens behind the scenes so you can keep editing the workbook while refreshing. 

Refreshing is done the same, familiar way as you’ve already been doing it. For example:

  • Select the Data tab > then choose Refresh All
  • Open the Queries Pane > then select Refresh


We’re continuing to work on enabling refresh for additional data sources 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 Power Query Refresh for additional data sources, automation support, and of course, releasing the full Power Query Editor experience to Excel for the web.



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.

Posted at https://sl.advdat.com/3M4QWG3https://sl.advdat.com/3M4QWG3