Forum Discussion
Error when connect to a excel file
Hi Everyone, When I connect to Excel, there is always an error that power BI couldn't figure out the column name and think column name is vacancy. Can you please give me some advice to import a ...
Looking at the data, have a check if you have any extra blank columns. These will have all values as Null. These would need to be removed, preferably from the source file first.
Once you get the data into your queries, are you running the step to "Make First Row as Header"?
I'd be looking at column D onwards. Excel can see these as having data even though they look blank to the eye.
Hi Ross,
I have found the step of "Use first Row as Headers" which you advised. That is a good way to solve this! Thanks a lot!
Regards,
Kelly