Forum Discussion

Anonymous

Not applicable

9 years ago

Solved

Error when connect to a excel file

When I connect to Excel, there is always an error that power BI couldn't find out the column name and think column name is vacancy.

Can you please give me some advice to import a Excel file? Thanks!

Anonymous
9 years ago
Hi Anonymous,

You can try to get data from excel , enter in query editor and 'Use first row as Headers' function:

In addition, I think your sheet contains multiple tables in it,right?

Regards,

Xiaoxin SHeng

2 Replies

Anonymous
Not applicable
9 years ago
Hi Anonymous,

You can try to get data from excel , enter in query editor and 'Use first row as Headers' function:

In addition, I think your sheet contains multiple tables in it,right?

Regards,

Xiaoxin SHeng
- Anonymous
  Not applicable
  9 years ago
  Hi Xiaoxin,
  
  Thank you for your help! That's so great!
  After following your steps, the column headers are updated.
  BTW, Inserting the data to table in Excel before connection is also the way to solve this. I found this today and I think your way is earlier to use.
  
  Regards,
  Kelly