Thank you for the reply. I had already checked the solution given unfortunately it doesnt help us since we are developing paginated reports and the reports are published as .rdl files. Here, we dont have the options mentioned in the link that you have provided.
Please find the task that we are trying to achieve in detail below:
1. Develop a paginated report and save the .rdl file in the azure repository.
2. Publish the rdl file from the azure repository using power bi actionn publish through a pipeline into a workspace.
3. In the worksapace we have an on-premises gateway. In this gateway we have data source connecting to our development, UAT and SIT databases all these are Oracle database.
4. When the RDLs are being developed we create a datasource and all datasets are being mapped to this datasource, the gateway will have a datasource with the same name created and the report will fetch the data from the particular data source for example RDL created and deployed with development database will connect to this database and fetch the data from development database.
5. If we need to fetch data from the UAT database we need to modify the RDL file manually using power bi report builder tool, create a new datasource for UAT and map the same with all the datasets and re-publish this report.
We are trying to come up with a solution to avoid changing the database in the RDL file manually everytime we want to view the report from a different database. We tried updateparameters option available in the API but it didnt work and also we tried find and replace text in rdl files through the pipeline action tasks and even that didnt help us.
Request you to kindly suggest if there are any other alternate solutions for this case. Any help would be greatly appreciated.
