Forum Discussion
PowerBi Report Builder
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
Super UserHi 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=%7C
For example, if your original paginated report URL is:
https://app.powerbi.com/groups/2d703b15-17a0-6d6b-4dce-6c4d4a7e7804/rdlreports/e19576e3-1a4a-bddc-baba-69f97cb37bdb
then instead navigate to:
https://app.powerbi.com/groups/2d703b15-17a0-6d6b-4dce-6c4d4a7e7804/rdlreports/e19576e3-1a4a-bddc-baba-69f97cb37bdb?rdl:format=CSV&rdl:FieldDelimiter=%7C
This 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