Forum Discussion
.csv no headers
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.
In the query editor, select your query, then in the transform area, select Use First Fow As Headers
2 Replies
In the query editor, select your query, then in the transform area, select Use First Fow As Headers
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
