Forum Discussion
PowerBi Report Builder
Hi All,
I have created a paginated report using data source as powerbi dataset. Now We have option to download the paginated report in the CSV format. When I download the file in CSV format I get values seperated by commas . I want to replace the commas with the pipe symbol("|"). Is it possible to achive this in paginated report i.e. when I download the paginated report in csv format I should get "|"(pipe symbol) instead of ","(commas) ?
Any help will be appriciated.
Thanks
sd22
Hi sd22
I'm not an expert on this by any stretch, but some searching/experimentation led to this as one option:
You can modify the Paginated Report URL by appending :
?rdl:format=CSV&rdl:FieldDelimiter=%7CFor example, if your original paginated report URL is:
https://app.powerbi.com/groups/2d703b15-17a0-6d6b-4dce-6c4d4a7e7804/rdlreports/e19576e3-1a4a-bddc-baba-69f97cb37bdbthen instead navigate to:
https://app.powerbi.com/groups/2d703b15-17a0-6d6b-4dce-6c4d4a7e7804/rdlreports/e19576e3-1a4a-bddc-baba-69f97cb37bdb?rdl:format=CSV&rdl:FieldDelimiter=%7CThis will then open the Paginated Report and immediately trigger the download of a CSV with the pipe delimiter.
Subsequently clicking Export will export a CSV in the same format.
Note: %7C is the encoding of the pipe symbol, and this could be replaced with any string you like.
Take a look at these pages for reference:
https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-builder-url-parameters
There could well be better ways of achieving this, or enabling some sort of global setting for the delimiter. Perhaps someone else will post some alternatives.
Regards
1 Reply
Hi sd22
I'm not an expert on this by any stretch, but some searching/experimentation led to this as one option:
You can modify the Paginated Report URL by appending :
?rdl:format=CSV&rdl:FieldDelimiter=%7CFor example, if your original paginated report URL is:
https://app.powerbi.com/groups/2d703b15-17a0-6d6b-4dce-6c4d4a7e7804/rdlreports/e19576e3-1a4a-bddc-baba-69f97cb37bdbthen instead navigate to:
https://app.powerbi.com/groups/2d703b15-17a0-6d6b-4dce-6c4d4a7e7804/rdlreports/e19576e3-1a4a-bddc-baba-69f97cb37bdb?rdl:format=CSV&rdl:FieldDelimiter=%7CThis will then open the Paginated Report and immediately trigger the download of a CSV with the pipe delimiter.
Subsequently clicking Export will export a CSV in the same format.
Note: %7C is the encoding of the pipe symbol, and this could be replaced with any string you like.
Take a look at these pages for reference:
https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-builder-url-parameters
There could well be better ways of achieving this, or enabling some sort of global setting for the delimiter. Perhaps someone else will post some alternatives.
Regards