Powerbi report builder: using parameters for DataSourceName in RDL

Hi All,

We are currently building paginated reports using powerbi reports builder with oracle database as the datasource. For each report we are creating an individual RDL file. At our customer's side we are having 3 different oracle database servers(DEV, UAT and PROD). We have to rebuild the RDL files everytime we need to fetch data from a different database and we are trying to figure out a way to avoid this.

We tried modifying the RDL file manually to get the datasource name from one of the parameter values but it didnt work. We also tried writing a custom function to change the datasource name based on a parameter value and that didnt help us too. We are publishing the report into app.powerbi.com where an on-premises gateway is setup and 3 different datasources are created in the gateway, in order to swith from DEV to UAT for example we have to rebuild the report with the UAT datasource name and then publish the report to view the data.

Can someone please let us know on how can this be achieved?