Use Append Queries Feature In Power BI

Introduction

 
To combine two or more files, we have imported the same structured files located in the same folder. See the article ‘How To Import Data From A Folder Into Power BI’. Here, I am using the ‘Append Queries’ feature in Power query editor to append two or more files located in different folders but have the same table structure.
 
‘Combine’ is a very powerful feature in the Power query editor. This feature has two types of queries:
  • Merge Queries
    This query option is used to merge two or more tables with conditions. These tables must have a common column like join.

  • Append Queries
    The append query is used to append the data of two tables with the same structure or a different structure.
I have already written an article on ‘Merge Queries’. You can check the below link for this.
To append two files, I am having two excel sheet ‘Employee1’ and ‘Employee2’ located in a different location. First, we will import these files in the power query editor, and then we will merge them.
 
Employee1
 
Use Append Queries Feature In Power BI 
 
Employee2
 
Use Append Queries Feature In Power BI 
 
Let’s start this article.
 
Step 1
 
Go to the ‘Home’ tab of Power BI tool to open the power query editor and click on ‘Transform Data’.
 
Use Append Queries Feature In Power BI
 
Once the power query editor is opened, import the first file into it by clicking on ‘New Source’. Select the ‘Excel’ source and give the file path of the file and open it.
 
Use Append Queries Feature In Power BI
 
Once you click on ‘Open’ a new ‘navigator’ window will open. Click on the checkbox of the sheet and click on ‘Ok’.
 
Use Append Queries Feature In Power BI
 
Similarly, we will add another source i.e. ‘Employee2’. Follow the same steps as above.
 
Use Append Queries Feature In Power BI
 
Use Append Queries Feature In Power BI 
 
Now we have two tables in the power query editor.
 
Use Append Queries Feature In Power BI
 
Step 2
 
Click on ‘Combine’ drop-down menu at ‘Home’ page, where you get ‘Append Queries’, click on ‘Append Query as New’. This will append two tables and create a new one.
 
Use Append Queries Feature In Power BI
 
Once you click on it a new ‘Append’ window will appear. Provide ‘Primary table’ and the table that needs to be appended on it.
 
Use Append Queries Feature In Power BI
 
Use Append Queries Feature In Power BI
 
You can rename this table as ‘Employee3’.And save these changes by click on ‘Close & Apply’ inside the ‘File’ tab. Now all these three tables will be shown on the Power BI dashboard.
 
Use Append Queries Feature In Power BI
 

Summary

 
Now we have two methods to combine and append multiple files. I have mentioned the link of the first method and this article is showing the second one. I have mentioned all steps in this article, hope you enjoy this article. Thanks for reading!