Power Query Problems

Fix Excel Power Query DataFormat.Error for a Source Workbook

Phi Hung VoPhi Hung Vo Nov 22, 2026 868 views

Question details

The user needs to resolve a Power Query refresh error that may be caused by a source table name or structure that does not match the query’s expectations.

Fix Excel Power Query DataFormat.Error for a Source Workbook
Product
Microsoft Excel Power Query
Device & OS
not provided
Scenario
Refreshing a query that retrieves data from multiple tables in a source workbook after a new table was added.
Observed behavior
Power Query reports DataFormat.Error with a binary corruption message, and the query does not retrieve the expected data.
Before you start

Identify the source workbook and any tables added or changed since the last successful refresh. In Excel, open Data > Queries & Connections to locate the affected query.

Solution 1Recommended

Match the New Source Table to the Query’s Naming Pattern

Use this solution when the error appeared after adding a table and the query expects table names or structures to follow a consistent pattern.

1
Inspect the query

In Excel, select Data > Queries & Connections, then right-click the affected query and choose Edit. Review Applied Steps or Home > Advanced Editor for table-name filters, parsing rules, and expected columns.

2
Check the new table name

Open the source workbook, click a cell in the newly added table, and select Table Design. Compare the Table Name field with the names of tables that the query already retrieves.

3
Correct the name and structure

In Table Design > Table Name, rename the new table to match the pattern required by the query. Also compare its column headers and layout with the existing tables, and correct any differences the query cannot handle.

4
Save and refresh

Save the source workbook, return to the workbook containing the query, and select Data > Refresh All. Confirm that the new table’s data is retrieved.

Match the New Source Table to the Query’s Naming Pattern
If the error persists: A naming mismatch is one possible cause, not proof that the workbook is undamaged. Check the error details and source workbook if the query still fails after the table name and structure match.
Free Microsoft Office alternative

Review Source Tables with WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. It can open Excel files for reviewing source data, making it easier to move between office suites, but it does not fix Microsoft Power Query errors.

Review spreadsheet source data in WPS SpreadsheetsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar interface for a smoother transition from Microsoft OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why can a table name cause a Power Query refresh error?

A query may filter table names or extract information from them using a specific pattern. If a new table uses a different format, the query may fail when processing it. Check Applied Steps or Home > Advanced Editor in Power Query Editor for those rules.

Where can I find an Excel table’s name?

Click any cell in the table and open the Table Design tab. The name appears in the Table Name field, where you can also change it.

Does the corrupted data message always mean the workbook is damaged?

No. In this case, a table name that did not match the query’s expected pattern caused the error. If correcting the name and structure does not help, inspect the error details and source workbook for other causes.

How do I refresh the query after changing a table name?

Save the source workbook, return to the Excel workbook containing the query, and select Data > Refresh All. Check that the expected data appears without an error.