Improve Report Deployment on Power BI Report Server

Qiuyun,

We can change the connection information on the report server but that does not change it in the .pbix file.  Even after changing the connection on the report server when we select "Edit in Power BI Desktop" the report that is opened is still pointing to the server from Dev.

What you suggest is true, "open the report in desktop within the Test environment and change data source points to the data source within Test environment, then publish the report to Test report server. "  However, this is an manual process, we have 25 semantic models and over 60 reports, doing this on each report is not a workable solution.   We need a way to automate the delivery of the reports and the updating of the connection information.    In addition, we are an ISV and we want to deliver our reports to 100s of client's and currently we need to update the connection information manaully for each customer.  Potentially,  100x60 = 6000 manually updates.