.csv no headers

[gamma]

Hi,

I'm a new/novice user.  I started today with BI Service and uploaded a .csv file.  It used the column headers in Row 1 of the .csv to name the fields.

I then downloaded PBI Desktop and loaded the same .csv but my Fields in the Desktop just show "Column1, Column2, ..."

Very odd.  Help appreciated.

[StanOil]

I solved this case in my own way:
1. I have created a file data_h.csv which contains column headers for the actual data file without headers: e.g. (id, header_1, header_2 etc.)
2. In Power BI - Power Query, add a query: from the txt/csv file (data_h.csv) (if present, remove the step: promote 1st row as headers)
3. add the 2nd query: from the txt/csv file - data file without header - (data.csv)
3. Add a query as a new one - combine rows from 2 tables as new ones: (1st: data_h.csv + 2nd: data.csv)
4. Use the 1st line as headings

[blopez11 · Accepted solution]

In the query editor, select your query, then in the transform area, select Use First Fow As Headers