Columns heading when exporting a Report Builder report to CSV

[krrose]

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 rather than the underlying dataset field names.

Has anyone configured a paginated report so that the CSV export uses the textbox labels instead of the field names? If so, what settings or properties need to be adjusted?

[v-achippa]

Hi @krrose,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @krrose,

Thank you for reaching out to Microsoft Fabric Community.

In Paginated Reports, CSV export is layout driven. The CSV column headers come from the tablix header textboxes, not directly from the dataset field names.

To ensure friendly column names in the CSV:

• Make sure the tablix has a proper static header row
• Make sure the header textboxes must contain the friendly display text
• Ensure headers are directly aligned above the data columns
• Update the textbox Name property (avoid default names)

If the tablix structure is clean and properly aligned, the CSV export will use the header text values.

Thanks and regards,

Anjan Kumar Chippa

[krrose]

Thanks for the replies and solution. Unfortunately it wasnt quite the solution I wanted. I wanted my column headings to contain spaces e.g. "Customer Number" but renaming the header textboxes does not allow spaces in the name.

[v-achippa · Accepted solution]

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

[v-achippa]

Hi @krrose,

We wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa