Append Queries
Power BI · Power Query (Data Transformation)
Theory
Append Queries stacks tables on top of each other: the rows of the second table are added below the rows of the first, matching columns by name. Columns that exist in only one table are kept and filled with null for rows from the other table. The result has the same columns and more rows, the opposite of Merge, which keeps the rows and adds columns.
For example, if sales arrive as one file per year, Sales_2023 with 4,000 rows and Sales_2024 with 6,000 rows, appending them gives one Sales table of 10,000 rows. With Append Queries as New, both source queries stay unchanged and a new combined query is created; you can then disable load on the yearly queries so only the combined table reaches the model. For many files in a folder, the Folder connector with Combine Files does this automatically.
Why we use it
Data is often split by year, region or system. Appending puts it into one table so measures, slicers and relationships work across all of it.
When to use it
Use Append when tables have the same structure and you want more rows. Use Merge when you want to add columns from a related table. For a folder of similar files, prefer Get data → Folder → Combine Files.
How it works
- Several tables with the same columns
- Do the column names match exactly? Yes: Continue to append. No: Rename columns first so they line up.
- Home → Append Queries as New
- Select the tables to stack
- Disable load on the source queries
- One combined table in the model
Syntax
Home → Append Queries | Append Queries as New
Two tables or Three or more tables
M:
Table.Combine(tables as list, optional columns as any) as tableExample
// Append Queries as New → query 'Sales'
let
Source = Table.Combine({Sales_2023, Sales_2024})
in
Source
// Then right-click Sales_2023 and Sales_2024 → uncheck 'Enable load'
// so only the combined Sales table is loaded into the model.Key points
- Append adds rows; columns are matched by name
- Mismatched column names create extra columns filled with null
- Append as New keeps the original queries untouched
- Disable load on helper queries to keep the model clean
- Folder connector + Combine Files appends many files automatically