Forum Discussion
krrose
6 months agoRegular Visitor
Columns heading when exporting a Report Builder report to CSV
I’m trying to export a Power BI Report Builder (Paginated) report to CSV, and I need the CSV output to use the display text (the friendly column headers with spaces) that I’ve defined in the report ...
- 5 months ago
Hi krrose,
Thank you for the response. The textbox name property is only an internal identifier in the report and it cannot contain spaces, but it does not control the csv column header text.
- In Paginated Reports, when exporting to csv, the column headers come from the value of the textbox in the tablix header row. So, to have headers like ‘Customer Number’ in the csv, set the desired text as the value of the textbox in the header row.
So, if the tablix contains a proper static header row and the header cells are aligned directly above the data columns, the csv export should use the textbox value as the column header.
Thanks and regards,
Anjan Kumar Chippa