Yes, Power Query is available in Excel for the web (browser), but only for viewing and refreshing existing queries—you cannot create or edit queries in the browser. This article explains exactly what you can do in the browser version, how it differs from the desktop app, and how to get the most out of it.
What Is Power Query in Excel?
Power Query is a data connection and transformation tool built into Excel. It lets you import data from various sources (like databases, web pages, CSV files, and folders), then clean and reshape that data before loading it into a worksheet or the Data Model. In Excel for Microsoft 365 on Windows, the full Power Query editor is available under the Data tab > Get Data. In the browser (Excel for the web), the editor is not available, but existing queries can be refreshed and their results viewed.
What You Can Do in the Browser
In Excel for the web, Power Query functionality is limited to:
- Refresh an existing query that was created in the desktop app.
- View the query results in a table on the sheet.
- See the query steps and source information (read-only).
You cannot open the Power Query Editor, add new queries, change steps, or modify the M code in the browser. This is a deliberate design choice by Microsoft—the full editor is a desktop feature.
How to Refresh a Query in Excel for the Web
If you have a workbook with a query that was created in Excel desktop, you can refresh it in the browser as follows:
- Open the workbook in Excel for the web.
- Go to the Data tab on the ribbon.
- Click the Refresh All button (or the refresh icon next to a specific query if you have the Queries pane open).
The refresh will re-run the query and update the data in the sheet. Note: this requires that the data source is accessible from your browser (e.g., a public web page or a file in OneDrive). If the source requires authentication, you may be prompted to sign in.
Key Differences: Desktop vs. Browser
The most significant differences are:
- Editing: Desktop allows full editing; browser is read-only for queries.
- Data sources: Desktop supports hundreds of connectors (SQL Server, Oracle, OData, etc.); browser only refreshes sources that are already defined and accessible.
- Performance: Desktop uses your local machine’s resources; browser uses cloud resources, which can be faster for large datasets but may have limits.
- M code: Desktop lets you view and edit M code; browser hides it.
If you need to modify a query, you must do it in the desktop app (Excel 2016 or later, or Microsoft 365). After saving and uploading the workbook to OneDrive or SharePoint, the changes appear in the browser.
Common Problems and Workarounds
Users often encounter these issues when using Power Query in the browser:
- “Refresh is greyed out” – This usually means the workbook is in a format that doesn’t support queries (e.g., .xls) or the query has been disabled by an admin. Convert to .xlsx and check with your IT department.
- Data source not accessible – If the source is a local file on your computer, the browser can’t reach it. Upload the source to OneDrive or use a cloud data source.
- Query results are not updating – Check that the query is set to refresh on open, or manually click Refresh All.
- “We couldn’t refresh the connection” – This often happens when the source requires a login. Sign in to the source in the browser, or use a stored credential in the query.
For most problems, the solution is to edit the query in desktop Excel, then re-upload the workbook.
How to Create a Query in the Browser (Alternative)
While you can’t use Power Query in the browser, you can still import data using built-in browser features:
- Data > From Text/CSV – This uses a simplified importer that lets you choose a file and load it as a table, but it doesn’t have the transformation steps of Power Query.
- Data > From Web – Similar to the desktop, but with limited options.
For complex transformations, you’ll need to use the desktop app. If you don’t have Excel desktop, consider using Google Sheets (which has a similar but separate “Data” menu) or a free tool like Power BI Desktop (which also uses Power Query).
Cost and Licensing
Power Query in Excel for the web is included with any Excel for the web subscription (free or Microsoft 365). The desktop version of Power Query is included in Excel 2016 and later, and in Microsoft 365. There is no extra cost for the feature itself. However, some premium connectors (e.g., certain database sources) may require a separate license or a Power BI Pro subscription if you use them in Power BI.
Frequently Asked Questions
Can I edit a Power Query in Excel online?
No, the Power Query Editor is not available in Excel for the web. You can only refresh and view query results. To edit, use the desktop app.
Why is my Power Query not refreshing in the browser?
This can happen if the data source is not accessible (e.g., a local file), if the workbook is in an older format, or if you’re not signed in to the source. Check the source and try refreshing again.
Is Power Query the same as Get & Transform?
Yes, “Get & Transform” is the name used in Excel 2016 and later for the Power Query technology. They are the same thing.
Can I use Power Query in Excel for free?
Yes, Excel for the web is free to use with a Microsoft account, and it includes the ability to refresh queries. The desktop version requires a paid license, but you can use the free trial or the Excel mobile app.
Does Power Query work on Mac?
Power Query is available in Excel for Mac (Microsoft 365) since version 16.54 (2021). The interface is similar, but some connectors may differ. The browser version on Mac is the same as on Windows.
Related
- Strings in R: Text, Character Vectors, and Examples
- Creating a Split Form in Access: Steps and Tips
- String Array Split in Java: Methods, Examples, and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Can You Make Lowercase Uppercase in Excel? Here’s HowYes. In Excel for Microsoft 365 on Windows, use the UPPER function to turn lowercase text into uppercase,…
- How to Copy an Excel Spreadsheet SafelyTo copy an Excel spreadsheet, choose what you need to duplicate: a worksheet, a selected range of cells,…
- Goal Seek Button in Excel: Where It Is and How to Use ItIn Excel for Microsoft 365 on Windows, find Goal Seek at Data > What-If Analysis > Goal Seek.…
- Google Sheets Filter Blanks: How to Find Empty CellsYes. In Google Sheets, select your data, choose Data > Create a filter, open the filter icon in…
- Excel Merge Across vs. Merge Cells: Key DifferencesMerge Across makes a separate merged cell for each row in your selection, while Merge Cells combines the…
- How to Mail Merge in Word UK: Step-by-Step InstructionsTo mail merge in Word, prepare a recipient list in Excel, connect it through Word’s Mailings tab, insert…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.