Forum Discussion

Rnaval's avatar
Rnaval
Icon for Post Partisan rankPost Partisan
1 year ago
Solved

Excel file imported without column headers

Hi All -

 

I have an excel file that I'm importing as a data source but the column headers are not being read from Row 1. Instead the columns are showing up as Column 1, Column 2, etc. Any way to fix this?

 

Thanks...

2 Replies

  • Hi Rnaval 

     

    In power query, you just have to select Use First Row as header

     

    Kind regards