Paginated Report export to CSV adding quotation mark only for selected lines

Question

Hi&nbsp;&nbsp;Paginated Report &gt; export to CSV &gt; adding quotation mark only for selected lines&nbsp;Details:I have a paginated report, and the report has only one column table.Each row is one full line of data. [we need to show the source file as download]when exported as CSV , it adds double quotes, if the row has comma (,).If there is no comma, then it won't add double quotes. this is by design.&nbsp;How to avoid double quotes when exporting from paginated report as CSV it in power bi service?&nbsp;Thanks&nbsp;Ref: By designhttps://docs.microsoft.com/en-us/sql/reporting-services/report-builder/exporting-to-a-csv-file-report-builder-and-ssrs?view=sql-server-ver15&nbsp;For SSRS, we did do by configuring different settings as&nbsp;https://docs.microsoft.com/en-us/sql/reporting-services/csv-device-information-settings?view=sql-server-ver15&nbsp;Ref: Similar issuehttps://stackoverflow.com/questions/59667551/ssrs-adding-extra-characters-when-exporting-to-csv&nbsp;&nbsp;

sevenhills · Answer

I did mention in the post, please check: ... when exported as CSV , it adds double quotes, if the row has comma (,).

More details:

a) If the data in a table column has a comma or other special characters, csv download is adding the double quotes. This is default behavior. I do NOT want double quotes.

b) I used to control this behavior this in SSRS Server configuration, not to add any double quotes. by adding one more download option as "CSV 2" and provided instructions to the report users.

https://docs.microsoft.com/en-us/sql/reporting-services/customize-rendering-extension-parameters-in-rsreportserver-config?view=sql-server-ver15

c) For the set of reports, I am working, the source is snapshot output files since 2000, of many reports, which are from other systems.

We are storing them and displaying as-is for the end user to download. Basically SSRS is acting as wrapper and facade to these data. hence these reports always has one column table and download the original source file.

Now, we are moving all SRSS reports to power bi service - paginated reports, not sure how to config and handle this scenario.

TIA

sevenhills · Answer

We come to the forum to seek help from those who did or from who know.&nbsp;I think you are not understanding the problem or you never checked my post completely.&nbsp;It is a common sense that we all know CSV means comma separated values. Sorry being little tough on the reply. Initially I thought you are helping, now you started talking the CSV meaning. I posted the links how it can resolved on on-premise SSRS or PBIRS. FYI, I am on SSRS since 2004 and I know how it behaves.&nbsp;You keep going to adding separator and how it processed or designed.&nbsp;&nbsp;We come to the forum to seek help from those who did or from who know.&nbsp;What I am asking is to how to fix / solution on PBI service?&nbsp;&nbsp;I saw to my other post also you replied the similar way.&nbsp; If you do NOT know the answer, you let others answer not giving this kind of reply.&nbsp;Please post the answer only if you know, if not allow others to answer.&nbsp;Appreciated in advance and thanks for the effort of your reply again.&nbsp;

lbendlin · Answer

when does this become an issue?&nbsp; Normally the CSV ingestion apps can handle quoted delimiters automatically.

lbendlin · Answer

I still don't see the issue.&nbsp; Power BI handles quoted data automatically, even if not every row is quoted.

sevenhills · Answer

I dont want the double quotes when exported from paginated report as csv.&nbsp;This is paginated report and I do understand it is default behaviour. This can be overwritten if it is on-premise PBIRS/SSRS server, check the links above. But for power bi service, I want to know how to do ...&nbsp;&nbsp;This is Not Self-Service Analytical Reports.&nbsp;

Forum Discussion

Paginated Report export to CSV adding quotation mark only for selected lines

10 Replies

Related content

PBI - quotation model

how to export csv file with quotation mark in paginated report

Paginated Report

Double Quotation (") - Identification and Removal

Paginated report