Troubleshoot Missing Rows When Appending Excel Power Query Tables
Question details
The user needs to determine why rows are missing after appending two Power Query tables and verify the applied query steps to locate the cause.

- Product
- Microsoft Excel Power Query
- Device & OS
- not provided
- Scenario
- The user appended two source tables in Power Query and expected the combined result to contain all rows, but some rows do not appear in the final output.
- Observed behavior
- The appended query result shows fewer rows than expected after it is loaded to a worksheet or table.
Open the workbook that contains the two source tables and the appended Power Query query, and note the expected row count of each source table before you inspect the query steps.
Check Row Counts in the Source Tables and Appended Output
Use this first to confirm whether rows are actually missing and where the row count difference appears.
Select each source table or named range in Excel, check the Status Bar row count, and write down the number of rows for each source.
Select the appended query result in its destination worksheet or table, then check the Status Bar row count or use Home > Find & Select > Go To Special > Last Cell to verify the used range.
Compare the total source rows with the appended result. If the appended result has fewer rows than expected, continue to inspect every Applied Step for filters, removed rows, deduplication, joins, errors, or changed data types.

Inspect Every Applied Step for Row-Reducing Transformations
Use this when the row counts confirm a difference and you need to find the exact query step causing the missing rows.
Verify the Load Destination and Refresh the Result
Use this when the query result is loaded but not all rows appear in the expected worksheet or table.
Use WPS Office as a Free, Lightweight Alternative for Excel Workbook Troubleshooting
If repeated Excel Power Query append errors interrupt your work, WPS Office Spreadsheets is a free, lightweight alternative that opens .xlsx workbooks, preserves familiar menus and formatting, and simplifies everyday table review and data management.
- 1. Download WPS Office Free: Go to the official WPS Office website and click Download WPS Office Free to get the installer.
- 2. Install and launch WPS Office: Run the downloaded installer, follow the setup prompts, and open WPS Office from the Start menu or Applications folder.
- 3. Open your Excel workbook in WPS Spreadsheets: Click Menu > Open, select the .xlsx or .xls workbook that contains the appended tables, and review the data in WPS Spreadsheets.

Frequently Asked Questions
Why does my appended Power Query table show fewer rows than the two source tables combined?
Usually a row-reducing step such as Remove Duplicates, Keep Rows, Remove Rows, or a Merge join kind changes the row count. Open the query in Power Query Editor and click through each Applied Step while watching the preview row count.
How can I check how many rows each Power Query source table has?
Select the source table in Excel and check the Status Bar row count, or load the source query to a table and count the rows. Then compare that number with the appended query result.
Can a Changed Type step remove rows when appending Power Query tables?
Yes, a Changed Type step or replace/error step can turn values into errors. Depending on load settings, error rows may be omitted. Inspect the step and review error rows in Power Query Editor.
Where should I look if my appended query is missing rows only in the worksheet?
Check the load destination, clear worksheet filters, unhide rows, and refresh the query. Also confirm the query was loaded as a table to the expected sheet.
Do I need the original Power Query steps to identify missing rows?
Yes, the Applied Steps in the query are usually required to identify the exact cause. A copy of the workbook or query steps helps isolate filters, joins, deduplication, or type changes.




