If Power Query is not working in Excel, first open Data > Queries & Connections, right-click the affected query, choose Edit, and check the first step showing an error; then verify the source path or credentials and select Data > Refresh All. Power Query issues most often come from a changed source, expired access, a renamed column, or a refresh setting—not from the query feature itself.
What Power Query does in Excel
Power Query is Excel’s data import and transformation tool. It connects to sources such as workbooks, text files, folders, databases, and some online services, then records the steps used to clean or reshape the data. The steps form a repeatable query: when the source changes, you can refresh the query instead of repeating the cleanup manually.
In Microsoft 365 for Windows, Power Query is part of the Data tab’s Get & Transform Data tools. Its editor shows a preview of the data and an Applied Steps list. A query can load results into a worksheet table, the Data Model, or remain a connection, depending on how it was created. Those choices affect where results appear, but do not necessarily mean the query has failed.
Power Query is not a live link that updates every cell immediately when a source changes. Results generally change when you refresh the query, and the refresh must be able to reach the source and repeat every transformation. A preview in the editor can also differ from the worksheet output if the query has not been refreshed or loaded after changes.
Start with the quickest checks
Before rebuilding a query, identify whether the problem is that you cannot find Power Query, cannot edit a query, see an error, or get old or missing results. These symptoms point to different causes. Try the checks below in order:
- Save a copy of the workbook, especially if it contains important query steps or output.
- Go to Data > Queries & Connections. If the pane is hidden, this command opens it. Confirm that the query is listed and note whether Excel shows an error or a connection-only query.
- Right-click the query and choose Edit. In Power Query Editor, look down Applied Steps to find the first step that displays an error. Later steps may fail only because an earlier one did.
- Check that the source file, folder, database, or web address still exists and that you have permission to access it.
- After correcting the issue, use Home > Close & Load in the editor, then Data > Refresh All in Excel. If only one query needs updating, right-click it in Queries & Connections and choose Refresh.
Refresh All can update multiple connections and queries, so it may take longer than refreshing one query. A slow refresh is not automatically a frozen application: large data sources, network drives, complex merges, and background refresh can all add time. If Excel appears unresponsive, allow the operation to finish before closing the workbook or starting another refresh.
When Power Query is missing or unavailable
First check which Excel application and version you are using. Power Query is built into modern Excel for Windows, including Microsoft 365. Older Windows releases have different arrangements: Excel 2010 and Excel 2013 used a separate Power Query add-in, while Excel 2016 and later integrated the tools into the Data tab. Instructions for the old add-in do not apply to current Microsoft 365 in the same way.
On Windows, look for the Get & Transform Data group on Data. If the ribbon is customized or the window is narrow, some commands may be tucked into a dropdown. Also check that the workbook is open in the desktop Excel application rather than a preview or another spreadsheet program. Excel for the web and Excel for Mac have Power Query capabilities, but available data sources, authoring features, and refresh options can differ by platform and update channel. If a command or source is absent, check Microsoft’s current feature availability for that Excel version rather than installing an unofficial add-in.
A workbook created on another computer may contain queries that your Excel build cannot edit or refresh in the same way. This can happen when the query uses a connector or feature that is not supported in that version. Ask the workbook’s creator which Excel version and source connector were used, then try opening it in an up-to-date desktop version that supports them.
Fix source paths, permissions, and credentials
A query that worked yesterday may fail today because the source moved, was renamed, or is no longer available from the current computer. For a file-based query, check the exact file or folder path. A path pointing to a personal Downloads folder or a mapped network drive may work only for the person who created it. If the source is on SharePoint, OneDrive, or a network location, make sure you are signed in with an account that can access it and that the location is available.
For sign-in or permission errors, go to Data > Get Data > Data Source Settings and inspect the permissions for the relevant source. Depending on the source and Excel build, you may be able to edit or clear its permissions and authenticate again during the next connection. Use the appropriate organizational account and authentication method; do not share passwords or place credentials in query text. In managed work environments, an administrator may control access or require a particular sign-in method.
If the source location changed, edit the query’s Source step in Power Query Editor. Select the step and use its settings button when one is available, or update the source through the connector’s dialog. Be careful when changing a path: later steps may assume a specific sheet name, table name, or folder structure. A query that points to a new file can still fail if that file’s contents are organized differently.
Resolve errors caused by changed data
Queries often break when the source structure changes. For example, a report may rename the column Order Date to Date, remove a field, add a header row, or change a date column into text. A later step that references the old column name or expects a date type can then fail. In the editor, select Applied Steps from top to bottom and inspect the first one marked with an error. The error message and the preview often reveal which expected field or value is missing.
Typical messages include DataFormat.Error when a value cannot be converted to the expected type, or an error saying a column was not found. Check whether the source contains unexpected headings, blank rows, mixed data types, or changed date formats. Correct the source when possible; otherwise, adjust the relevant transformation and verify that the result still makes sense for all rows, not just the sample shown in the preview.
A Formula.Firewall message is another common stumbling block. Despite the name, this is generally about Power Query’s privacy isolation between data sources, not a Windows firewall blocking Excel. When a query combines sources, Power Query may prevent data from one source from being passed to another because of privacy settings. Review the privacy levels and permissions for each source in Data Source Settings, following your organization’s rules. Do not set sources to ignore privacy protections simply to silence an error if the data is sensitive.
Understand refresh, load, and stale results
If a query refreshes without an obvious error but the worksheet still looks unchanged, check where the query loads and whether the visible output is actually its result. In Queries & Connections, a query marked as connection-only may not create a table on a worksheet. Right-click it and inspect Load To, if available, to choose an appropriate destination. The Data Model is not displayed as a regular worksheet range.
Also confirm that the correct query was refreshed. A workbook can have several queries, and one may depend on another. Refreshing only a downstream query may not update a source query in the way you expect. Data > Refresh All is useful when you want Excel to refresh workbook connections and queries together. Review the query’s Properties for refresh-related options, such as whether it refreshes when the workbook opens. Background refresh can allow other work in Excel while a connection runs, so the displayed output may not update until that process completes.
Power Query’s editor preview is not always a guarantee that the complete output has loaded to the sheet. Previewing uses a limited view to help you inspect transformations, while loading processes the query for its destination. If the preview is correct but the sheet is not, close and load the query, check its load destination, then refresh and wait for completion.
Workbooks, compatibility, and safe troubleshooting
If other people use the workbook, consider whether they can access the same sources and whether the workbook is saved in a format that preserves the query. A query that depends on a local file path may work for its creator but fail for colleagues. A shared, stable source location and clear instructions about sign-in make refresh more reliable. When transferring a workbook, include the source files only when you are allowed to share them and the query is intended to use those copies.
Avoid deleting queries or clearing all permissions as a first response. Those actions can remove useful steps or require connections to be configured again. Make a backup, record the exact error, and change one thing at a time. If a query was created by someone else, ask before changing transformations that determine how the report is interpreted. When working with confidential data, use only approved locations and privacy settings.
When to use another approach
If your Excel version cannot refresh a particular connector, possible alternatives depend on the source and your organization’s tools. You might open the source in a supported desktop version of Excel, ask the data owner to provide a compatible export such as a CSV file, or use an approved database or reporting tool. A CSV export can solve a connector compatibility problem, but it is a snapshot: it does not preserve a live connection to the original source.
For a small, stable task, ordinary Excel tools such as sorting, filtering, or formulas may be enough. For recurring imports and transformations, Power Query is often more repeatable because it stores the cleanup steps. Switching tools is not automatically a fix, however: source permissions, inconsistent data, and changing column names can cause problems in other software too.
Frequently Asked Questions
Why is Power Query not showing in Excel?
Check that you are using a version and platform with the relevant Power Query features, and look on the Data tab for Get & Transform Data. Older Excel versions may require a legacy add-in, while Mac and web capabilities differ from Windows desktop Excel.
Why does Power Query say a column was not found?
The source may have renamed, removed, or reformatted the column, or an earlier step may have changed its name. In Power Query Editor, find the first failing item in Applied Steps and compare the expected column name with the current source headings.
How do I refresh Power Query in Excel?
Choose Data > Refresh All to update workbook queries and connections, or right-click a query in Data > Queries & Connections and choose Refresh. A refresh needs access to the source and may take time for large or complex data.
Why does my query refresh but the worksheet does not change?
Check that you refreshed the intended query, that it is loaded to a worksheet rather than connection-only or the Data Model, and that refresh has finished. The editor preview and worksheet output are separate views of the query.
Can I use Power Query in Excel for Mac or Excel for the web?
Power Query is available in some current Mac and web versions, but feature and connector support is not identical to Microsoft 365 for Windows. Check the specific source and operation against Microsoft’s current availability information for your version.
Related
- Open a DB File in Excel: Methods, Limits, and Options
- Open CSV in Excel Without Losing Leading Zeros
- Office Contact List Template Excel: Build a Useful Directory
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Find Not Working? Causes and Fixes ExplainedExcel’s Find command usually fails because it is searching the wrong sheet or selection, looking in formulas instead…
- SUMIFS Excel: Common Errors and How to Fix ThemSUMIFS errors usually come from a misplaced argument, ranges that do not match, or criteria that do not…
- COUNTIF Not Working? Fix Common Excel Counting ErrorsIf COUNTIF is not working properly in Excel, first check that its range and criterion refer to the…
- Excel Flash Fill Not Recognizing a Pattern? Fix ItIf Excel Flash Fill is not recognizing your pattern, enter one or two clear examples beside the source…
- Excel #DIV/0! Error: Make the Cell BlankYes. To make a division error show as a blank-looking cell, use =IFERROR(A2/B2,"") when the numerator is in…
- Excel WEEKDAY Function Not Working? Fix Common CausesIf Excel’s WEEKDAY function is returning an error or an unexpected number, first confirm the cell contains a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.