how to export csv file with quotation mark in paginated report

[Phylicia]

Hi,

I am using paginated report to send data to users in csv file, and I want the columns with quation mark after export. For example,

I have col A: ABC

I want col A: "ABC"

But if I manually add "" in the dataflow, in the export file it shows """ABC"""

How should I change it so that I can have "ABC", not ABC or """ABC"""?

Thank you so much

[V-yubandi-msft]

Hi @Phylicia ,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[V-yubandi-msft]

Hi @Phylicia ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[V-yubandi-msft]

Hi @Phylicia ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[V-yubandi-msft]

Hi @Phylicia ,

Thank you for reaching out to the Microsoft Fabric Community. This is a common point of confusion with paginated reports and CSV exports. As the @rohit1991  mentioned, Power BI follows standard CSV rules when exporting data, adding quotation marks around values only if necessary.

Regarding the ForceQuotes setting in the RSReportServer.config file, it is available only in on premises SSRS (SQL Server Reporting Services), not in Power BI Service. Currently, there is no setting in Power BI Service to force quotes on all exported fields.

If quoting every field is essential for your use case, you can export the report to Excel and then use a script (PowerShell or Python) to convert it to CSV and apply custom quoting logic.

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

[rohit1991 · Accepted solution]

Hi @Phylicia,

In a paginated report, when exporting to CSV, Power BI automatically wraps fields in quotation marks only when needed—for example, if the field contains a comma, quote, or line break. If you manually add quotes in your dataset (e.g., turning ABC into "ABC"), the CSV export will escape those quotes, resulting in """ABC""" in the file, which is standard CSV behavior to avoid confusion with actual delimiters. To get output like "ABC" without triple quotes, you should not add quotes manually in the dataflow or expression.

Instead, let the export engine handle it. If you absolutely need every field to be wrapped in quotes regardless of content, you can customize the CSV rendering extension in SQL Server Reporting Services (SSRS) by modifying the RSReportServer.config file—setting ForceQuotes to true in the CSV rendering settings. However, this is a server-side setting and affects all reports. Unfortunately, Power BI Report Builder doesn’t currently offer a per-report setting for forced quoting in CSV. For a workaround, consider exporting as Excel and converting to CSV with quoting logic via a script if precision is critical.