Forum Discussion
Solved
.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 load...
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