When we have a few reports on the development environment, it is not that complicated to deploy that on the QA and PROD environments. Basically, we make copies of those reports for each of those environment, adjust the connectivity to point to their respective database servers, and publish the reports to those environments.

But, when we have 200 reports, it is kind of complicated to adjust all those reports whenever we deploy. I took a look at the database holding the data for Power BI. It turns out the connectivity parameters are encrypted in one of the tables. Thus, it is not possible to adjust all those reports using script. I have heard of a deployment pipeline extension to Power BI. I do not know if this applies to Power BI Report Server. How are you doing it when comes time to deploy?