Forum Discussion
excel Load button grey
Only way i was able to get the Load button to appear, not grayed out, in Navigation, was to save my file as a .csv. Simply saving it as an Excel Workbook, not macro enabled, did not do the trick.
However, now when i load the .csv worksheet, the columns and headers appear in Data View, but no data at all.
Im using Excel 2013 and a brand new download of Power BI Desktop
I'm having the same problem after using the Power BI for a couple of weeks.
I'm attempting to load a very simple Excel table with no luck.
I have performed a clean reinstall to see if this corrects problem to no avail.
1 a 2 b 3 c 4 d 5 e 6 f 7 g 8 h 9 i 
When you open an excel file you are greeted with a tree of the file and a list of all of the tabs. Are you using the checkbox to select which tabs to import? Even if the file has only a single tab, you need to place a check mark in the box.
I appreciate your response.
It is exactly what I forgot to do.:smileyhappy:
Gary
