Forum Discussion
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
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
- OwenAuger
Super User
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?
- ChasInSantaCruzNew 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
- ChasInSantaCruzNew 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