How to Append Two Tables in Power BI
Appending two tables in Power BI allows you to combine the rows of two different tables into one table. This can be useful when you want to consolidate data from multiple sources or when you have similar data split across different tables. You can follow the steps below to append two tables in Power BI.
Step 1: Import the Tables
First, you need to import the tables you want to append into Power BI. You can do this by going to the “Home” tab and clicking on the “Get Data” button. Choose the appropriate data source and select the tables you want to import.
Step 2: Load the Tables
Once you have imported the tables, you need to load them into the Power BI data model. To do this, click on the “Close & Apply” button in the Power Query Editor. This will load the tables into the data model.
Step 3: Append Tables
To append the tables, you need to click on the “Append Queries” button in the “Home” tab. This will open a dialog box where you can select the tables you want to append. Choose the tables you want to combine and click on the “OK” button.
Step 4: Review and Edit
After appending the tables, you should review the appended table to ensure it has the desired structure and data. You can make any necessary edits by clicking on the “Transform Data” button in the “Home” tab.
Step 5: Apply Changes
Once you are satisfied with the appended table, you need to apply the changes by clicking on the “Close & Apply” button in the Power Query Editor.
Step 6: Use the Appended Table
Now, you can use the appended table in your Power BI report by selecting it in the “Fields” pane. You can create visualizations, apply filters, and perform other data analysis tasks using the appended table.
Example
Let’s say you have two tables: “SalesData1” and “SalesData2”. Both tables have the same columns: “Product”, “Quantity”, and “Revenue”. You want to append these two tables to create a single table with all the sales data.
SalesData1:
Product Quantity Revenue
---------------------------------
A 10 100
B 20 200
C 15 150
SalesData2:
Product Quantity Revenue
---------------------------------
D 30 300
E 25 250
AppendedTable:
Product Quantity Revenue
---------------------------------
A 10 100
B 20 200
C 15 150
D 30 300
E 25 250
In this example, the tables “SalesData1” and “SalesData2” are appended to create the “AppendedTable” with all the sales data from both tables.