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
ARMARM's avatar
ARMARM
Copper Contributor
Oct 20, 2025

Thank you very much for finally pushing this functionnality to prod.

I have 2 remarks yet:

  1. As already stated, it doesn't seem to be possible to use Office Script / Power Automate to refresh queries using workbook.refreshAllDataConnections(). When available, it will likely unlock impressive business cases,
  2. Confidentiality level seems to be set by default to private, with no way to change it to public or organizational. And from my understanding, when merging data from different sources, this setting is crucial (only tested with Excel table data source).
Tom1260's avatar
Tom1260
Copper Contributor
Dec 23, 2025

Even with the right confidentiality levels, it seems that it is still not possible at all to refresh queries from different sources (tested a combination of a Sharepoint Folder connection and a CurrentWorkbook() connection combined). It would be great if that would be enabled, like in the desktop version!