PowerBI Report builder - CSV with No header or customized header including space

[goms12]

PowerBI Report builder - CSV with No header or customized header including space "Project Name"

Have created the rdl report and issue not able to download big size excel file which is having 1 million rows. But able to download via CSV thru onedrive option. But column name is coming from actual table column name with _ for example Project_Name instead of "Project Name"

Need solutions for the same.

1) How to run the csv report without header (So that I can add one data row as header column) to solve the header issue)

2) If header is possible means How to include the header with spaces on it.

[PeterKessler]

There is a nice and still valid article about removing the header here:

Rendering data in a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsof...

In a nutshell, you need to go to the properties of the text box and work with the DataElementName setting there.

[Anonymous · Accepted solution]

Hi, @goms12 

I had a test, I create a sample table in Power BI report builder and export to CSV:

Then open the csv file with the Notepad and excel

I don't seem to see anything unusual in my tests, can you provide more information about the problem and no personal privacy

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[goms12]

if you see your table has column name as "Ticket ID" - Note that there is space present in between words Ticket and ID. but in your output notebook screenshot header has Ticket_ID, Ticket_Desc ...I don't want to have this kind of output rather than without underscore and with space("Ticket ID").