![]() We hope you like this new addition to Excel and we’d love to hear what you think about it! 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!įuture 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’re continuing to work on enabling refresh for additional data sources as well as with other features. Open the Queries Pane > then select Refresh.Select the Data tab > then choose Refresh All.Refreshing is done the same, familiar way as you’ve already been doing it. The refresh happens behind the scenes so you can keep editing the workbook while refreshing. ![]() In addition, you can also start with a blank query, write some M code, and refresh it. 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. See this support article for more information on Power Query data sources in Excel versions. This new functionality is available to all users on Excel for the web. Queries refresh asynchronously, instead of one-by-one, enabling faster refresh.Queries refresh in the background so you can continue working on the grid.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.īy 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.
0 Comments
Leave a Reply. |