Forum Discussion

Rnaval's avatar
Rnaval
Post 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 f...
  • Cookistador's avatar
    1 year ago

    Hi Rnaval 

     

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

     

    Kind regards