Excel: Refresh queries from Authenticated Data Sources in Excel for the Web

Excel: Refresh queries from Authenticated Data Sources in Excel for the Web

Excel for the Web has made it possible to refresh Power Query data from authenticated data sources. This means that data sources requiring authentication can now be refreshed in Excel for the Web. This feature is set for general availability release in October CY2023 and is accessible from various cloud instances - GCC High, GCC, DoD, Worldwide, and more. Created on August 23, 2023, this new development has been tracked under Roadmap ID 65632.

If you are looking for enhanced data management capabilities in Excel for the Web, this update proves a significant stride forward for consuming data from authenticated sources and keeping them updated in real-time. For more details on this feature, you can check out the roadmap link at https://www.microsoft.com/microsoft-365/roadmap?featureid=65632 or read the post on M365 Admin.

Published on:

Learn more
M365 Admin
M365 Admin

by João Ferreira

Share post:

Related posts

How to Interpolate in Excel

In the world of data analysis, interpolation is a powerful tool that helps estimate values that fall between known data points, often used to ...

3 months ago

How to Join Data Sources in Tableau in 4 Simple Steps

If you're struggling to join data sources in Tableau, look no further. This tutorial breaks down the process into four simple steps, allowing ...

5 months ago

Microsoft Forms: Supports live data sync to Excel

In a convenient and time-saving development, Microsoft Forms now offers live data synchronization with Excel. By syncing your form responses t...

6 months ago

Top 40+ Excel Interview Questions for Data Analysts:

Preparing for an Excel interview but don't know where to start? Look no further than this comprehensive guide to mastering Excel interview que...

6 months ago

Action Required – Changes to Get & Transform Data (aka Power Query) features in Excel

Excel users, take note: changes are coming to the Get & Transform Data (aka Power Query) features in the program. Starting March 11th, 202...

7 months ago

Can Excel Pull Data from a Website? Top 3 Ways Explained

Copying and pasting data from a website into Excel is a thing of the past. With this article, you'll discover three easy and accurate ways to ...

7 months ago

What is a Query in Excel? Step-By-Step Guide With Examples

Queries are a powerful tool available in Excel for data management. They help quickly find and process data from various internal or external ...

8 months ago

What is Power Query: A Step-By-Step Guide for Data Analysis

In the realm of data analysis, performing repetitive tasks in Excel or Power BI can be exhausting. But fear not, because Power Query is here t...

1 year ago

How to Use Power Query in Excel: The Complete Guide

Power Query is an excellent business intelligence tool in Excel that facilitates data import, cleaning, and transformation as per your require...

1 year ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy