Microsoft has officially integrated the full Power Query functionality into Excel for the web, a significant enhancement for users who rely on data manipulation and automation. This update allows users to import, transform, and automate data workflows without needing to access the desktop application.
Power Query serves as Excel’s ETL (extract, transform, load) tool, enabling users to connect to various data sources, clean data, and reshape it effectively. Users can perform tasks such as fixing column headers, removing null values, and reshaping datasets with minimal effort, which streamlines processes that traditionally required extensive manual input.
Enhanced Functionality in the Browser
Previously, Excel for the web lacked many features present in the desktop version, particularly when handling complex Power Query setups. Users often encountered limitations, such as being unable to refresh data requiring specific authentication. Although users could view cleaned data in the browser, they could not modify the underlying query logic or access new data sources.
With the latest update, users can utilize the online Get Data wizard to import data from sources like SQL databases, SharePoint lists, and OData feeds directly within their browser. Excel for the web now supports cloud-based authentication methods (OAuth2), allowing users to refresh data from sources like SharePoint or SQL servers seamlessly.
Collaboration and Flexibility
This enhancement promotes collaboration, as multiple team members can access and modify query logic from any device with a browser, eliminating the need for a single user to manage data cleaning on their local machine. Additionally, the web version ensures consistent functionality across different devices, regardless of the Excel version installed.
However, it is important to note that, for now, data sources must primarily be cloud-based. While the desktop version can easily access local files, the web version currently focuses on sources like OneDrive and SharePoint. Microsoft has indicated that support for local files is planned for the future.
Availability and Future Plans
As of now, viewing and refreshing existing queries is accessible to all Microsoft 365 subscribers. However, the ability to create and edit queries is limited to users on Business or Enterprise plans. Microsoft aims to expand Power Query’s capabilities in Excel for the web by adding more data sources and advanced features, although there is no timeline for when these updates will be available for personal or family accounts.
This article was produced by NeonPulse.today using human and AI-assisted editorial processes, based on publicly available information. Content may be edited for clarity and style.
