Power Query Problems

Investigate Incorrect Excel Power Query Data in a Headerless Table

John WilsonJohn Wilson Nov 14, 2026 868 views

Question details

Investigate why a previous data row appears in the expected header position when a headerless Power Query output becomes empty.

Product
Microsoft Excel Power Query
Device & OS
not provided
Scenario
A query output table starts on row 2 or later, has no visible header row, and initially contains data. A subsequent filter returns no rows.
Observed behavior
The previous last data row may appear in the expected header position even though the query result has no data rows.
Before you start

Identify the affected query and confirm that its output table starts on row 2 or lower and has no visible header row. Note whether the query initially returns at least one row before applying the empty-result filter.

Solution 1Recommended

Reproduce and document the empty-result behavior

Use these steps to confirm the conditions and collect information for further investigation.

The reported behavior has been reproduced, but the supplied information does not establish a fix. The steps below help distinguish an empty query result from the row still visible on the worksheet.

1
Check the output table

Select the query output table in Excel and open Table Design. Confirm that Header Row is unchecked, the table starts on row 2 or lower, and at least one data row is visible.

2
Filter the query to zero rows

Open Data > Queries & Connections, right-click the affected query, and select Edit. In Power Query Editor, use a column filter to exclude all rows and verify that the preview is empty.

3
Load and inspect the result

Select Home > Close & Load. On the worksheet, check whether the previous last data row appears where the header would normally be, and confirm whether any query data rows were loaded.

4
Capture investigation details

Take screenshots of the table before and after filtering. Reopen the query and select Home > Advanced Editor to copy its query code; remove sensitive information before sharing the screenshots and code with support.

Reproduce and document the empty-result behavior
Investigation status: A visible row in the expected header position does not by itself establish that the query returned a data row. Check the Power Query preview and worksheet output separately.
Free Microsoft Office alternative

Review spreadsheet data with WPS Spreadsheets

WPS Office is a free, lightweight alternative for opening and editing spreadsheets in a familiar interface. Its Microsoft Office format support can help you move existing workbooks to WPS; it does not fix Excel's Power Query behavior.

Open and review spreadsheet data in WPS SpreadsheetsCompatible with Microsoft Excel formats, including XLSXUse a familiar interface for everyday spreadsheet editingMove existing workbooks into a lightweight, free office suite
microsoft office alternative - wps office

Frequently Asked Questions

How can I check whether the query actually returned zero rows?

Open Data > Queries & Connections, right-click the query, and select Edit. Check the filtered result in Power Query Editor, then use Close & Load and inspect the worksheet output.

Where do I turn off the output table's header row?

Select a cell in the output table, open the Table Design tab, and clear the Header Row checkbox.

What information should I provide for investigation?

Capture screenshots of the table before and after the filter, note its starting row and header setting, and copy the query code from Home > Advanced Editor. Remove sensitive information before sharing.

Does WPS Office fix this Excel Power Query issue?

No. WPS Office is an alternative for spreadsheet work, but it does not fix the behavior in Microsoft Excel Power Query.