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
Jul 23, 2025

Merging of queries from different data sources still doesn't work. As for me that's main showstopper.

jokahati wrote:

Refresh is limited to 1000 connections per user.

That's per hour, per day, per month or for entire life?

In #shared environment we have about 1200 objects against 850 in desktop, depends on subscription and channel. Data source credentials are in different environments and are set independently. Does that mean potentially we have compatibility issues shifting from web to desktop and back working with file?

 

  • jokahati's avatar
    jokahati
    Icon for Microsoft rankMicrosoft
    Jul 23, 2025

    I will clarify - the limit is for 1000 data source credentials.
    For example, if you connect to the same data source with 2 different users, it counts as 2.