I missed an excel sheet on a data source addition. how can i go back and add it?

[jimmyg706]

Hi

Ive just realised I needed another sheet on my source excel file in Power BI desktop.

Sheet 1 was imported last wee  but now I need sheet 2.

Do I just import sheet 2 as if it was  a xls datasource?

Comments welcome

Jimmy

[Sahir_Maharaj · Accepted solution]

Hello @jimmyg706,

To add another sheet after you've already imported data, you don't have to start your import process from scratch. Can you please try the following steps:

1. Go to the Home tab > Get Data

2. Select your file > Select the new sheet to import (The Navigator window will open, displaying all the sheets)

3. Load or Transform Data: You have two options here:

   • If you need to perform any transformations or clean up the data, click on "Transform Data".
   • If no transformations are needed, you can click "Load" to directly add the new sheet's data into your Power BI model.

Hope this helps!

[v-yaningy-msft · Accepted solution]

Hi, @jimmyg706 

Did you solve the problem, please? You can follow @Sahir_Maharaj steps to re-add the data. In Power BI Desktop you can put your new data table in the previously imported xls and just use the same steps as importing a normal xls file again.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Sahir_Maharaj · Accepted solution]

Hello @jimmyg706,

To add another sheet after you've already imported data, you don't have to start your import process from scratch. Can you please try the following steps:

1. Go to the Home tab > Get Data

2. Select your file > Select the new sheet to import (The Navigator window will open, displaying all the sheets)

3. Load or Transform Data: You have two options here:

   • If you need to perform any transformations or clean up the data, click on "Transform Data".
   • If no transformations are needed, you can click "Load" to directly add the new sheet's data into your Power BI model.

Hope this helps!