Forum Discussion
xls missing first column
Hi. I have recive new bach of data from our web developers in xls format and meet strange begavior in power query grabber. I try to load single file and folder, but in both case i dosn't see fir...
Hello Zaknafeein
there are some weird problems when reading a xls-file. Maybe this file was also created by a 3rd party software.
So here some solutions to it
- try format your data as real table and then read the data from the table and not from the sheet
- try to open the file and save it as the same file once more
- save it as XLSX-file
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy