Forum Discussion
Paginated Report export to CSV adding quotation mark only for selected lines
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.
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
I still don't see the issue. Power BI handles quoted data automatically, even if not every row is quoted.
I dont want the double quotes when exported from paginated report as csv.
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 ...
This is Not Self-Service Analytical Reports.
Have you considered using a different field separator, like the pipe symbol?
I assume you read all my previous replies. I will restate again for your clarification:
Paginated report contains only one table, and the table has only one column.
Say, if your CSV paginated report output is 10 lines, and only two lines have comma, then quotes are added to those two lines. For the remaining 8 lines it won't add quotes. This is the default behavior.
So, pipe symbol separator is not option, as there is only one column in the table.
I appreciate your patience in providing options and solution to me.