Fix Excel Power Query DataFormat.Error for a Source Workbook
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.

- 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.
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.
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.
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.
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.
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.
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.

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.

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.




