Forum Discussion
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....
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
OwenAuger
Super User
Super UserYou 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
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