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

[ChasInSantaCruz]

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

[OwenAuger · Accepted solution]

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?

[OwenAuger · Accepted solution]

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 · Accepted solution]

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]

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