Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Regular Visitor

Export Power BI paginated report to a CSV file text box Expression working or not ?

Hi All,

We have trying to export to excel sometime loading failed. So we have trying to export to CSV it's downloaded but tablix's column (header text box) Expression not correct format any ideas for this.


Thanks and Regards,

Vijay Srinivasan

Regular Visitor

Hi rpatkar,
I have set to DataElementName ("Full Name")this is error bacase of two word between space than this type how to fixed.

Thanks and Regards,

Vijay Srinivasan

DataElementName needs to be CLS compliant so cannot have space in it. You can use 'Full_Name' for example. Please refer to these articles to learn more - reporting services - How to customize the header of the CSV file that exported by a SSRS report - St... & [MS-RDL]: Report.DataElementName | Microsoft Learn

Power BI Team
Power BI Team

hi Vijay, header values in case of export to CSV use the DataElementName from the RDL. In Report Builder, please properties window on right, set the DataElementName to desired string and then do an export to CSV to check output.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors