Forum Discussion
Helper IIInot able to load excel file
Hello
I am trying to load a simple excel file into power Bi. I get no error when I load the file. Strangely when I try to view the data, I see nothing on the sheet. But when I go into query editor, I can see data... Why is this happening
My best guess is that you have blank lines in your data that sort on top after loading your table.
7 Replies
svishwanathanHello
I am trying to load a simple excel file into power Bi. I get no error when I load the file. Strangely when I try to view the data, I see nothing on the sheet. But when I go into query editor, I can see data... Why is this happening
- tjd
Impactful Individual
Did you press the "Close and Apply" button on the query window? If so, you would see PowerBI applying your query results.
- svishwanathan
Hello
I did do close and load but doesnt work. Also I used get data to pull this excel file but when I didn't see anything on my sheet, out of curiousity I checked the edit query tab. I did this also because when I loaded the data, the preview showed me all columns.Also when i go into the chart or BI mode, I can pull the differenet headers and data populates except for case numbers which is teh first column
Is it something I need to do with the excel file before I load it
- MarcelBeug
Community Champion
My best guess is that you have blank lines in your data that sort on top after loading your table.
- svishwanathan
Awesome.....thanks so much...I spent the whole day yesterday feeling miserable that i couldnt even load data.....Thanks so much again
