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.
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:
Select Home > Transform Data.
Then go to Home Ribbon. Click on Append Queries Drop-down. You’ll get two options.
- Append Queries
- Append Queries as New
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).
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.
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.