Pivot Table Issues

Fix Excel Pivot Tables Empty After a Power Query Refresh

Maira MehtabMaira Mehtab Nov 18, 2026 869 views

Question details

The user needs to restore PivotTable data after refreshing Power Query and resolve key-matching errors on another computer.

Fix Excel Pivot Tables Empty After a Power Query Refresh
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the query

In Excel, select Data > Queries & Connections, right-click the query feeding the PivotTable, and choose Edit.

2
Inspect the source

In Power Query Editor, select Source under Applied Steps and check that the file path and source are correct and accessible.

3
Find the failing step

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.

4
Check rows and data types

Review filter and Changed Type steps in Applied Steps. Adjust filters or column data types if they remove expected rows or produce errors.

5
Load the query again

Select Home > Close & Load, then confirm that the query completes and returns the expected rows before refreshing the PivotTable.

Check the Power Query source and applied steps
What a key-matching error means: The query may be looking for a sheet, table, or other item whose name no longer matches the source. Check the Navigation step and the names in the source file.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in a familiar interfaceCompatible with Microsoft Excel XLSX and XLS formatsUse PivotTable tools to summarize spreadsheet dataFree and lightweight for everyday office work
microsoft office alternative - wps office

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.