Forum Discussion

Anonymous

Not applicable

9 years ago

Solved

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 Excel file? Thanks!

Regards,

Kelly

Anonymous
9 years ago
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"?

6 Replies

Anonymous
Not applicable
9 years ago
Hi Kelly, You'll need to post a lot more information if you want some help. Can you give us access to a demo version of your file in question? Does the connection work the first time, but fail on later refreshes after you've updated your file?
- Anonymous
  Not applicable
  9 years ago
  Hi
  
  Yes,it is the first time I connected to this Excel file. And I find that the failure happened to my connection everytime.
  Community can't upload the Excel file and I don't know how to get the URL of file, so I insert the image.
  Excel File
  This is the image of import result preview.
  Could you tell me your email? If OK, I will send the file to you by email.
  
  Best Regards,
  Kelly
  - Anonymous
    Not applicable
    9 years ago
    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"?