Power Query Problems

Troubleshoot Missing Rows When Appending Excel Power Query Tables

Maira MehtabMaira Mehtab Nov 13, 2026 868 views

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.

Troubleshoot Missing Rows When Appending Power Query Tables
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.
Before you start

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.

Solution 1Recommended

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.

1
Record the source table row counts

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.

2
Check the appended query output row count

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.

3
Compare the counts and continue if they differ

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.

Check Row Counts in the Source Tables and Appended Output
Row counts usually reveal the missing stage: If the row counts match after accounting for legitimate transformations, the missing rows are likely caused by an earlier filtering, join, or load setting.
Free Microsoft Office alternative

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. 1. Download WPS Office Free: Go to the official WPS Office website and click Download WPS Office Free to get the installer.
  2. 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. 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.
Lets you open and inspect .xlsx, .xls, and .csv workbook data with Microsoft Office format compatibilityFree and lightweight spreadsheet application with a familiar tab-based interfaceHelps you review appended table data and compare rows without an Office 365 subscriptionSimple migration from Microsoft Excel with similar ribbons, formulas, and shortcutsPreserves workbook formatting and table structure when you switch from Excel
microsoft office alternative - wps office

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.