Blog Post

Excel Blog
3 MIN READ

New in Excel for the web: Power Query Refresh & Data Source Settings for authenticated data sources

jokahati's avatar
jokahati
Icon for Microsoft rankMicrosoft
Jul 22, 2025

We’re excited to share the latest addition to Excel for the web: Power Query Authenticated Refresh and Data Source Settings 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 selected authenticated data sources.  As we released the abil...
Updated Sep 02, 2025
Version 4.0
excel
Get Data
Power Query
Refresh
Naiad12321's avatar
Naiad12321
Copper Contributor
Jul 24, 2025

Is it possible to refresh Power Query using Office Script? I’m trying to retrieve data via Power Query from an Excel file stored in a SharePoint Folder.

  1. I could refresh it in Excel for the web.
  2. After that, I tried using `refreshAllDataConnections()` in Office Script to update the data, but it didn’t work.
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 24, 2025

Right now it doesn't work, perhaps will be implemented in some future