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

  1. Several tables with the same columns
  2. Do the column names match exactly? Yes: Continue to append. No: Rename columns first so they line up.
  3. Home → Append Queries as New
  4. Select the tables to stack
  5. Disable load on the source queries
  6. 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 table

Example

// 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

Power BI topics

Power BI Introduction

Getting Data

Power Query (Data Transformation)

Data Modeling

DAX (Data Analysis Expressions)

Data Visualization

Dashboards & Reports

Power BI Service

Advanced Features

Projects & Case Studies

Interview & Certification

Advanced DAX & Time Intelligence

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Power BI Dashboards & DAX

Learn data visualization and interactive dashboards step-by-step. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice DAX Online 250 business scenarios on a star schema — write a measure and compare your visual with the expected one. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Power BI  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax / Where to find it
{{ current.syntax }}
Example
{{ current.example }}
What You'll Learn — click to check off
  • {{ pt.mark }} {{ pt.text }}

Share this topic