Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
goms12
New Member

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.

1 REPLY 1
v-yohua-msft
Community Support
Community Support

Hi, @goms12 

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

vyohuamsft_3-1727056278245.png

 

vyohuamsft_1-1727055640910.png

Then open the csv file with the Notepad and excel

vyohuamsft_2-1727055968122.png

vyohuamsft_5-1727056383254.png

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.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors