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!

  • MinhDuc1301's avatar
    MinhDuc1301
    Copper Contributor
    Oct 21, 2025

    Totally agree. Lot of wonderful business cases will be unlocked if it is possible to automate refreshing w/o opening the file

  • jokahati's avatar
    jokahati
    Icon for Microsoft rankMicrosoft
    Oct 21, 2025

    Thank you for the feedback, ARMARM​ !

    We are looking into both remarks, and update accordingly.