Forum Discussion

ChasInSantaCruz's avatar
ChasInSantaCruz
New Member
1 year ago
Solved

Import Excel Workbook into Power BI Not Working - Load and Transform Data are Gray

Hi, 

 

I am unable to import an Excel 2019 workbook into Power BI. 

Steps taken:

1. "Get Data"

2. "Excel Workbook"

3. "Connect"

4. Select workbook from local folder

5. "Open"

 

Details:

1. Load and Transform Data buttons are Gray

2. There are two worksheets in the workbook with the same data: Table1 and SalesOrderDetail.

3. There is no formatting or filtering in the worksheets.

4. I am doing the Power BI training from Microsoft. The Excel workbooks came directly from Microsoft as downloads.

5. None of my Excel workbooks are working regardless if they are from Microsoft or not. 
6. I have the August 2024 Power BI update

 

Am I doing anything incorrectly? Please help!

 

Thank you so much for your time and consideration with this issue!

 

Grateful!

 

Charles from Santa Cruz, California

 

  • Hi ChasInSantaCruz 

    You need to select the checkbox next to the sheet(s) or table(s) in order to be able to load/transform:

    Does that work for you?

  • Owen! That worked!
    I wasn't given the choice to Load or Transform Data but that is not a problem at all! 

    You are so The Man!

     

    Charles

3 Replies

  • Hi ChasInSantaCruz 

    You need to select the checkbox next to the sheet(s) or table(s) in order to be able to load/transform:

    Does that work for you?

    • ChasInSantaCruz's avatar
      ChasInSantaCruz
      New Member

      Owen! That worked!
      I wasn't given the choice to Load or Transform Data but that is not a problem at all! 

      You are so The Man!

       

      Charles

      • ChasInSantaCruz's avatar
        ChasInSantaCruz
        New Member

        Clarification. 

        Though I wasn't given Load or Transform Data I was given an OK which uploaded it into my model. 

        Very much appreciated!

         

        Charles