Forum Discussion

krrose's avatar
krrose
Regular Visitor
6 months ago
Solved

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 ...
Paginated Reports
report builder
  • v-achippa's avatar
    v-achippa
    6 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

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
6 months ago

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's avatar
krrose
Regular Visitor
6 months ago

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's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    6 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

    • v-achippa's avatar
      v-achippa
      Icon for Community Support rankCommunity Support
      5 months ago

      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