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).
  • 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.