Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have a paginated report that I have to export as a CSV and the column names contain spaces. in SQL I replaced all the spaces in the names with underscores, and then pagianted report column headers removed them as expected. However when I export the report as CSV from PBI Service, it is retaining the SQL column names, not the column names from the row header in the RDL. Is this normal or am I missing something?
Hi @srduval ,
You're right, this behavior is expected in Power BI Service when exporting paginated reports to CSV.Go back to your SQL and consider modifying the column names permanently to remove spaces. This ensures consistency across Power BI and avoids confusion during export.
Try below Approch if this works
Open your paginated report in Report Builder.
Click on the text box displaying the column header with the desired name (including spaces).
In the Properties pane, locate the property named "Value." This property defines the text displayed in the report.
You can set the "Value" property to an expression that references the actual column name (with underscores) but formats it to include spaces.
For example, if the actual column name is "Total_Sales," you could set the "Value" property to ="Total " & Fields!Total_Sales.Value
Thanks for the reply. My SQL columns don't have spaces, but the output column headers MUST have spaces. This is not my choice, but a requirment of the third party that I am creating the CSV for to be imported into their system. Why they wrote a database import specificiation to require spaces in their column headers is beyond me, but my hands are tied. I think my only option at this point would be to move the data retrival and export into power automate where I can control the CSV output more granularly.
@KarthigaM22 No in the interest of time I just exported it to excel and told the end user how to resave as a CSV. The only workaround I can think of is to use power automate to query the source data, then create a CSV file with custom headers.
Thanks for your response, have to follow Power automate approach then.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
34 | |
30 | |
18 | |
12 | |
8 |
User | Count |
---|---|
51 | |
35 | |
29 | |
14 | |
12 |