Forum Discussion
Importing multiple sheets with same structure
Hi Anonymous ,
You can simply append both the files from Power Query Editor:
1. Get both datasets to Power BI file
2. Go to Power Query Editor
3. Click on "Append Queries" or "Append Queries As New"
Append Queries: Over-writes the table currently
Append Queries As New: Creates new table
4.1. For Append Queries, Click on 1st dataset(In your case, it will be file with data from 2016-18) -> click on append queries and select the dataset in append(In your case, it will be file with data from 2019 onwards) in table to append dropdown
4.2. For Append Queries As New, Click on append queries -> Select Primary table as 1st dataset(In your case, it will be file with data from 2016-18) and table to append(In your case, it will be file with data from 2019 onwards)
5. Click OK
Note: For appending 3 or more tables in one go, a radio button will be available in append queries window.
The sample ,you provided:
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
Hi Anonymous ,
You can simply append both the files from Power Query Editor:
1. Get both datasets to Power BI file
2. Go to Power Query Editor
3. Click on "Append Queries" or "Append Queries As New"
Append Queries: Over-writes the table currently
Append Queries As New: Creates new table
4.1. For Append Queries, Click on 1st dataset(In your case, it will be file with data from 2016-18) -> click on append queries and select the dataset in append(In your case, it will be file with data from 2019 onwards) in table to append dropdown
4.2. For Append Queries As New, Click on append queries -> Select Primary table as 1st dataset(In your case, it will be file with data from 2016-18) and table to append(In your case, it will be file with data from 2019 onwards)
5. Click OK
Note: For appending 3 or more tables in one go, a radio button will be available in append queries window.
The sample ,you provided:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien