Importing multiple sheets with same structure

[Anonymous]

Hi

I've an excel file that has multiple sheets. All the sheets have the same data structure.

What I would like to do is to do transformation for one sheet and then append all sheets together and apply same transformation.

I know how to do this with multiple excel sheets, but for multiple sheets it's different.

[v-luwang-msft]

Hi @Anonymous ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft · Accepted solution]

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

[littlemojopuppy]

Hi @Anonymous 

Can you provide a sample Excel file to play with?

[Anonymous]

@littlemojopuppy 

Here is the link