export to csv comma separated

Try to change the DeviceInfo settings for the CSV rendering extension:

Check FieldDelimiter field in the spec: https://docs.microsoft.com/en-us/sql/reporting-services/csv-device-information-settings

This page shows how rendering extensions can be tweaked in general: https://docs.microsoft.com/en-us/sql/reporting-services/customize-rendering-extension-parameters-in-rsreportserver-config

try this:

1º export to csv file, from powerbi report.

2º Open excel,

3º New file -> menu data-> from text/CSV (and select the csv file exported).

3º Select delimiter;

3º Load.