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
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 21, 2025

Power Query editor like in online version appeared. Great, thanks!

Data Source Settings disappeared and no ability to work with GW. Bad.

Is it possible to update us from time to time which functionality is supported?

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

    Hi SergeiBaklan​ ,

     

    We are gradually releasing features and will share a formal update once we are ready.

    Regarding Data Source Settings, please drop me an email/message with details.

    Thanks!

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Oct 22, 2025

      jokahati​ , I'm sorry, found Data Source Settings in drop down menu. However, didn't find an option here to select GW. Is it still in development?

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

        Hey SergeiBaklan​ ,

        PQ in Excel for the web doesn't support gateways yet. We are looking into it for the future.