How to Append Query with Power BI

In this blog, we will be appending two different queries using PowerBI. This feature is very useful if you want to combine two data tables. We can also append more than 2 tables using PowerBI.


Description automatically generated

In the above screenshot, we have sales data for the years 2021 and 2022.

Now, we’ll combine the above 2 data tables. Below are the steps to append them:

Step 01:

Select Home > Transform Data.

Step 02:

Then go to Home Ribbon. Click on Append Queries Drop-down. You’ll get two options.

  • Append Queries
  • Append Queries as New

Step 03:

When we will click Append Queries as New a new window will appear as shown below.

Select the Two tables option as we are Appending 2 tables. If you want to append more than 2 tables, you can select the other option (Three or more tables).

And below you will get the option to select the table. After selecting both tables click OK to append both tables (Sales 2021 and Sales 2022).

Step 04:

After clicking OK your tables will be appended as a New Table. You can rename the table (Sales Data). And click the Close and Apply button present in the ‘Home’ tab Ribbon to save all the changes.

Graphical user interface, application, table, Excel

Description automatically generated

In the below screenshot, you will be able to see the new appended table as Sales Data.

So, in this blog, we have learned how to append queries.


Addend Analytics is a Microsoft Gold Partner based in Mumbai, India, and a branch office in the U.S.

Addend has successfully implemented 100+ Microsoft Power BI and Business Central projects for 100+ clients across sectors like Financial Services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Switzerland, and Australia.

Get a free consultation now by emailing us or contacting us.