PowerBi Report Builder

[sd22]

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

[OwenAuger · Accepted solution]

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=%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/device-info/csv-device-information-sett...

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