How to How to Append Queries in Power Query in Excel in Excel - Practical Guide

Learn to combine multiple queries into a single dataset using Append in Power Query. This advanced technique merges data from different sources or tables with identical structures, eliminating manual consolidation and enabling automated data workflows for complex analytical scenarios.

Why This Matters

Appending queries streamlines consolidation of multi-source data, reduces manual errors, and maintains dynamic refresh capabilities for reporting on distributed datasets.

Prerequisites

•Basic understanding of Power Query Editor interface
•Multiple queries with identical column structures already created
•Access to Excel 365 or Excel 2016+ with Power Query enabled

Step-by-Step Instructions

Open Power Query Editor

Navigate to Data > Get Data > From Other Sources > Blank Query, or go to Data > New Query > From Other Sources > Blank Query to access Power Query Editor.

Load Your First Query

In Power Query Editor, ensure your first query is already loaded and visible in the Queries pane on the left side.

Access Append Queries Function

Click on your first query to select it, then navigate to Home tab > Append Queries > Append Queries as New (or Append Queries if modifying existing).

Select Queries to Append

In the Append dialog box, choose Two tables or Three or more tables depending on your needs, then select the specific queries from the dropdown lists to combine.

Verify and Load Results

Review the appended data in the preview pane to ensure all rows are combined correctly, then click Close & Load to import the consolidated dataset into Excel.

Alternative Methods

Append Using Merge Instead

Use Merge Queries for combining data based on common keys or columns rather than stacking rows; ideal for side-by-side data consolidation.

Manual Union via Concatenate

Manually concatenate table references in M code using the & operator for advanced custom append scenarios requiring conditional logic.

Append All Queries from Folder

Load multiple files from a folder using Combine & Load from Folder feature to automatically append all matching files in bulk.

Tips & Tricks

✓Ensure all queries have identical column names and data types before appending to avoid mapping errors.
✓Use Append Queries as New to preserve original queries while creating a new consolidated table.
✓Test with two queries first before appending three or more to understand the behavior.
✓Document the source of each query in a new column using Add Column > Custom Column with query names.

Pro Tips

★Use Table.Combine() in M code for dynamic appending of variable numbers of tables without rebuilding dialogs.
★Combine Append with transformations by applying steps before appending to ensure consistent data quality across sources.
★Create a parameter-driven append workflow to dynamically select which queries to combine based on user input.
★Monitor query dependencies in the Power Query diagram view to track which appended queries feed into downstream reports.

Troubleshooting

Appended table shows only some rows from each query

Check for filtered rows in source queries using View > Applied Steps; remove Filter steps from source queries before appending or apply filtering after appending for consistency.

Column order changes after appending

Reorder columns in each source query identically before appending, or use Choose Columns step after appending to enforce consistent column sequence.

Appended query fails to refresh

Verify all source queries are still accessible and haven't been deleted; check Data > Refresh All and review error messages in the Query Editor status bar.

Memory or performance issues with large appends

Apply filters and remove unnecessary columns in each query before appending to reduce dataset size, or split into multiple smaller appends.

Related Excel Formulas

Table.Combine()Table.Concatenate()Merge Queries Transform > Combine > Combine Files

Frequently Asked Questions

Can I append queries with different column counts?

No, Power Query requires identical column structures. Create matching column sets in each query first using Select Columns or Add Column steps to ensure compatibility before appending.

What's the difference between Append and Merge?

Append stacks rows vertically combining tables with identical structures (union), while Merge combines columns horizontally based on matching keys (join). Choose Append for consolidating similar datasets.

Can I append more than 10 queries at once?

Yes, use Append Queries > Three or more tables and select multiple queries from the dropdown list. Alternatively, use advanced M code with Table.Combine() for unlimited queries.

How do I track which query each row came from after appending?

Add a custom column before appending using Add Column > Custom Column with a formula that references the query name, or use Index column to identify sources post-append.

Will appended data update automatically when source queries refresh?

Yes, appended queries automatically refresh when source queries update if created using Append Queries as New. Changes propagate dynamically through the dependency chain.