If Excel Power Query is not importing data, first identify whether the failure happens while connecting to the source, transforming the preview, or loading the result into the workbook. In Excel for Microsoft 365 on Windows, open Data > Queries & Connections, edit the query, and check the first step that shows an error; then verify the source path, sign-in, privacy settings, and load destination.
Start with the stage where the import fails
Power Query separates getting data from shaping it and loading it. A source can connect successfully while a later transformation fails, and a query can preview correctly but still fail when it writes results to a worksheet. Knowing which stage is affected prevents random changes to a working part of the process.
- No preview or connection error: Check the file path, website address, database availability, network, and credentials.
- Preview appears, but an Applied Step shows an error: Select the failing step in Power Query Editor. The source may have changed, or a transformation may no longer match the data.
- Preview works, but nothing appears in Excel: Check the query’s load settings, destination, and refresh status.
- Only some rows or columns appear: Inspect filters, removed-column steps, sample-file logic, and the selected worksheet or table.
To inspect a query, choose Data > Queries & Connections, right-click its name, and select Edit. In the Power Query Editor, the Applied Steps list shows the sequence of operations. Selecting steps one at a time can reveal where the preview first becomes incorrect or displays an error.
Check the source location and connector
A common cause is that the source has moved or changed. For a workbook or text file, confirm that the file still exists at the path shown in the query. A path to a local Downloads folder, removable drive, or another person’s user folder may work on one computer and fail on another. If the file is in OneDrive or SharePoint, confirm that it is available and that the link or site address has not changed.
To change a source path, edit the query and inspect the Source step. You can also use Data > Get Data > Data Source Settings to review or change source permissions and, where available, source locations. Be careful when editing a URL: a page address copied from a browser is not always the same as a direct address intended for a data connector. Some websites require a supported connector or an authenticated API rather than a normal page link.
For a new connection, use the connector that matches the source, such as Data > Get Data > From File > From Workbook or From Text/CSV. The preview is useful for confirming that Power Query has selected the intended sheet, table, delimiter, and columns before you load anything. If the expected object is missing, check whether it is actually a named Excel table, a worksheet, or a different file.
Look for changes in the source structure
Queries often depend on column names and data types. If a monthly report renames Customer ID to Client ID, a later step that selects Customer ID may fail. If a source adds a title row, changes a delimiter, or replaces a worksheet with a table, Power Query may interpret the same file differently. In the editor, compare the current preview with the query’s expected layout and review steps such as Promoted Headers, Changed Type, Removed Columns, and Renamed Columns.
CSV imports deserve a close preview check. A wrong delimiter can put an entire row into one column, while an encoding mismatch can make accented characters look corrupted. In the Text/CSV preview, confirm the delimiter and file origin before choosing Transform Data or Load. If values such as dates or decimal numbers are interpreted incorrectly, select the relevant column and use Transform > Data Type > Using Locale to choose a type and locale that match the source. For example, dates written as day/month/year can be misread if interpreted using a month/day/year locale.
Power Query can also assign types automatically. Automatic type detection is convenient, but it may infer a number for a column that later contains text, or infer dates based on a sample that does not represent every row. Review the Changed Type step and set a suitable type deliberately. Do not simply delete every type step: correct types matter for sorting, calculations, and consistent refreshes.
Check sign-in, permissions, and privacy settings
A source may be reachable but still reject the account Power Query is using. This can happen after a password change, when a file is moved to a restricted folder, or when a database or SharePoint site requires a different organizational account. Open Data > Get Data > Data Source Settings, select the relevant source, and review its permissions. If appropriate, clear the stored permissions and connect again, choosing the correct authentication method and account.
Privacy-level prompts can affect queries that combine sources. Excel uses privacy settings to help control how data from one source may be combined with another. If a query combines, for example, a local workbook with an online list, a privacy warning or Formula.Firewall error may appear. In Data > Get Data > Query Options, review the privacy settings and assign levels that accurately reflect the sources, such as Public, Organizational, or Private where those options are available. Do not lower privacy protections just to suppress a warning unless you understand what data is being combined and where it could be sent.
Network restrictions can look like query problems too. A corporate VPN, proxy, firewall, expired database session, or temporary service outage can block access. If the same source works in a browser but not through Power Query, the connector may use a different authentication flow or require IT-approved access. Ask an administrator about permissions and approved connection methods rather than putting passwords directly into query steps.
Confirm that the query is set to load
Power Query queries can be configured as connection-only, loaded to a worksheet, or added to the Data Model. A connection-only query may refresh successfully without creating a visible table on a sheet. In Queries & Connections, right-click the query and choose Load To, or use the arrow beside Home > Close & Load in Power Query Editor. Choose Table and select a worksheet or a new worksheet if you need visible rows. Choose Only Create Connection when the query is intended as an intermediate step for another query.
Loading to a worksheet also has limits. A worksheet can contain at most 1,048,576 rows, so a larger result cannot be displayed there in full. For larger datasets, consider loading to the Data Model instead, if that suits the workbook and your analysis. Check that the selected destination sheet is not protected or otherwise preventing the result from being placed where expected.
After loading, use Data > Refresh All to update the workbook’s queries. In Queries & Connections, check the status and any error message; a refresh can take time for a large file or a remote source. To review automatic refresh behavior, right-click the query, choose Properties, and inspect the available refresh options. Background refresh can make it seem as if Excel has finished before the result is ready, so wait for the refresh to complete before judging the output.
Read the error instead of guessing
Power Query errors often identify the failing operation. A File Not Found message points toward a path or availability problem. An authentication error suggests that credentials or access rights need attention. A Formula.Firewall message commonly relates to privacy when combining sources. A column-not-found error usually indicates that a source header changed or an earlier step removed or renamed the column.
Select the error cell or step to view details, then compare those details with the source itself. If the source is an Excel workbook, open it separately and confirm that the expected sheet or table still exists. If the failure occurs only during refresh, check whether the source’s schema or permissions differ from the data used when the query was first created. Avoid replacing a failing step with a broad workaround until you know which source change caused it; otherwise the query may appear to work while silently excluding important data.
For recurring imports, make the source predictable. Keep column headers stable, use named Excel tables rather than ranges that shift, and store recurring files in a consistent location. When files arrive with different names but the same structure, use a folder-based import where appropriate, then validate the sample file and combine steps. This is more resilient than editing a new file path every month, but it still depends on consistent columns and file formats.
Excel for Mac, Excel for the web, and other options
This guidance is for Excel for Microsoft 365 on Windows, where the Power Query Editor and connector set are most extensive. Excel for Mac supports Power Query features, but connector availability and editing capabilities can differ by Excel version and source. Excel for the web can refresh some existing queries, but not every connector or query operation is supported there. If a workbook works on Windows but not on another platform, check the current Microsoft support information for that platform and connector before rebuilding the query.
If the data source offers a direct Excel export, downloading a fresh CSV or workbook can help determine whether the problem is specific to the connector. For a repeatable process, Power Query is generally preferable to manual copy-and-paste because its recorded transformation steps can be refreshed. But it is not a guarantee that every source can be accessed: licensing, authentication, connector support, and organizational policies still apply.
Frequently Asked Questions
Why does Power Query show data in the preview but not in my worksheet?
The query may be connection-only, loaded to another sheet, still refreshing, or configured for the Data Model. In Queries & Connections, right-click the query and choose Load To to check or change its destination.
Why does Power Query say the column was not found?
A source header may have changed, or an earlier step may rename or remove that column. Inspect the Applied Steps list and compare the relevant step with the current source headers before changing the query.
How do I fix a Power Query credential error?
Go to Data > Get Data > Data Source Settings, select the source, and review or clear its saved permissions. Reconnect with an account that has access, using the authentication method required by the source.
Why does a CSV import put everything in one column?
The delimiter selected in the import preview may not match the file. Reopen the Text/CSV import, choose the correct delimiter, and verify the preview before loading. Also check the file origin if characters display incorrectly.
Can I recover a query that stopped working after the source changed?
Often, yes. Identify the first Applied Step that fails, then update that step to match the new path, header, sheet, or data type. If the source format changed substantially, it may be safer to recreate the source connection while preserving useful transformation steps where possible.
Related
- Excel Power Query: How to Hide or Remove Columns Easily
- Vertex42 Budget Spreadsheet: How to Choose and Use One
- Excel Power Query: How to Group Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Change Strikethrough Color in Excel Cells EasilyExcel does not let you set a strikethrough line to a different color from the text. You can…
- Unhide Columns in Excel: Keyboard Shortcuts and StepsTo unhide columns in Excel for Microsoft 365 on Windows, select the column headers on both sides of…
- Delete Row in Excel: Methods and Keyboard ShortcutsTo delete a row in Excel for Microsoft 365 on Windows, click its numbered row heading, right-click, and…
- Excel Box Plot With Data Points: How to Show Every ValueYes. In Excel for Microsoft 365 on Windows, select the box-and-whisker chart, open Format Data Series, and under…
- How to Add a Shared Mailbox in Outlook for iOS AppTo add a shared mailbox in Outlook for iOS, sign in with the work or school account that…
- Excel Neutral Color Code: Hex Values and How to Use ItExcel has no single official “neutral color code”: neutral can mean white, black, or a shade of gray,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.