Forum Discussion
Unable to import excel file
I am having trouble loading any excel file of any size onto power BI. I made sure the file was in the correct .xlsx format and have tried undownloading and redownloading. When I select the desired sheet on the left from the excel file the "Load" or "Transform Data" buttons don't appear as buttons to choose from and I am forced to cancel.
I have the desired sheet selected on the left. The two button options "Load" or "Transform Data" do not appear as options for me and am forced to choose cancel.
Hi Anonymous
When you check one of the pages/tables, the options to Load and Transform Data will be activated.
4 Replies
- gmsamborn
Super User
Hi Anonymous
When you check one of the pages/tables, the options to Load and Transform Data will be activated.
hi! i am having the same issue and have done what you suggested. & the option to load and transform data does not appear. its greyed out.
Hi gmsamborn
Thank you for your response but yes, I have selected a sheet/table on the left and it still does not get activated.
- gmsamborn
You have to check the check-box to the left of one or more of the table/page names.
