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