Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
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
In the query editor, select your query, then in the transform area, select Use First Fow As Headers
User | Count |
---|---|
83 | |
70 | |
69 | |
66 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |