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
Employee2
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’.
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.
Once you click on ‘Open’ a new ‘navigator’ window will open. Click on the checkbox of the sheet and click on ‘Ok’.
Similarly, we will add another source i.e. ‘Employee2’. Follow the same steps as above.
Now we have two tables in the power query editor.
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.
Once you click on it a new ‘Append’ window will appear. Provide ‘Primary table’ and the table that needs to be appended on it.
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.
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!