Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.