Forum Discussion
PowerBI Report builder - CSV with No header or customized header including space
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.
Hi, Anonymous
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.
3 Replies
Hi, Anonymous
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.
There is a nice and still valid article about removing the header here:
In a nutshell, you need to go to the properties of the text box and work with the DataElementName setting there.
