Forum Discussion
Paginated Report export to CSV adding quotation mark only for selected lines
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.
CSV stands for comma separated values. In reality the separator can be any character or character sequence. Ideally the separator does not appear in the actual data. If it does then it needs to be protected/quoted. The system is not smart enough to realize that you only have one column. It will try to protect the separator character regardless.
See if you can change the default field separator to something other than a comma.
We come to the forum to seek help from those who did or from who know.
I think you are not understanding the problem or you never checked my post completely.
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. You keep going to adding separator and how it processed or designed.
We come to the forum to seek help from those who did or from who know. What I am asking is to how to fix / solution on PBI service?
I saw to my other post also you replied the similar way. If you do NOT know the answer, you let others answer not giving this kind of reply. Please post the answer only if you know, if not allow others to answer.
Appreciated in advance and thanks for the effort of your reply again.
You don't appear to have understood either. Even though there is only one column PBI is still looking to see if the text contains the delimiter. If you change the delimiter to pipe, which won't appear in the text, then it won't add the quotation marks at all.
As far as I can tell there is no way to disable the qualifier in PowerBI, you can change it, but it has to exist as an option.
