Fix Excel Pivot Tables Empty After a Power Query Refresh
Question details
The user needs to restore PivotTable data after refreshing Power Query and resolve key-matching errors on another computer.

- Product
- Microsoft Excel Power Query and PivotTables
- Device & OS
- not provided
- Scenario
- A workbook containing Power Query queries and PivotTables is refreshed or opened on another computer.
- Observed behavior
- PivotTables become empty after a refresh, or a key-matching error appears on another computer.
Confirm that the source files are accessible on both computers and that you have permission to open them. Identify the query feeding each affected PivotTable in Data > Queries & Connections.
Check the Power Query source and applied steps
Use this solution when a query returns no rows or reports that a key does not match any rows.
In Excel, select Data > Queries & Connections, right-click the query feeding the PivotTable, and choose Edit.
In Power Query Editor, select Source under Applied Steps and check that the file path and source are correct and accessible.
Select each item under Applied Steps, especially Navigation, and look for a renamed or missing sheet, table, column, or other item. Update the source or edit the affected step to match the current names.
Review filter and Changed Type steps in Applied Steps. Adjust filters or column data types if they remove expected rows or produce errors.
Select Home > Close & Load, then confirm that the query completes and returns the expected rows before refreshing the PivotTable.

Refresh the query and verify the PivotTable connection
Use this solution if the query returns rows but the PivotTable is still empty.
Compare source access and connection settings on both computers
Use this solution when the workbook works on one computer but fails on another.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel formats, making it easy to move everyday workbook tasks between applications. Excel Power Query refresh errors still need to be fixed in Excel.

Frequently Asked Questions
Why does Power Query say the key did not match any rows?
A query may reference a sheet, table, or other item that was renamed or removed. Open Data > Queries & Connections, edit the query, and inspect the Navigation step under Applied Steps.
Why is my PivotTable empty even though the query has data?
The PivotTable may use a different source or need a separate refresh. Click the PivotTable, check PivotTable Analyze > Change Data Source, and then right-click the PivotTable and select Refresh.
Why does the workbook fail only on another computer?
The other computer may not have access to the same source path, file, or credentials. Compare the source files and review Data > Get Data > Data Source Settings on both computers.
Should I refresh the query or the PivotTable first?
Refresh the query first from Data > Queries & Connections and confirm it returns the expected rows. Then right-click the PivotTable and select Refresh.




