Change Datasource In report

Question

Hello,&nbsp;I developed a report in a development environment, whose data comes from a local SQL server. The report has to be deployed on a production environment pointing to the corresponding production SQL server...&nbsp;However, once deployed on the power bi report server, it is not possible to adapt the server name, impossible to change the data source! and it is not possible to do it from the development environment because the production SQL server is not accessible from the development environment.&nbsp;How to do it?&nbsp;Thanks,&nbsp;Regards,&nbsp;Hervé&nbsp;&nbsp;&nbsp;&nbsp;

bradsy · Answer

Manage\Data Sources on the report.

hervema · Answer

&nbsp;Of course not, that would have been the right thing to do of course, but it is not possible to modify the data source once deployed (grayed out) 😞

flynn · Answer

Hi all, &nbsp;having the same issue. It's not possible to realize a professional development pipiline yet.My Workaround:Work with an alias for the sql server in file C:\Windows\System32\Drivers\etc\hostsUse the same alias with different hosts in every environment and use this alias in the Power BI Report.&nbsp;Best Regards&nbsp;

anonymous · Answer

This is indeed very annoying.&nbsp;In order to work around it, everytime we want to deploy a report to production we copy it to a staging VM with Power BI Desktop installed, open the report and change the datasources to production and then deploy it to the production Report Server.&nbsp;I believe that the reason they do not allow the change directly is that the data inside the report would still be from the developpment environment until the next scheduled refresh but they could simply force a refresh after changing a data source.

Forum Discussion

Change Datasource In report

4 Replies

Related content

Datasource column name changed

Change in Datasource Problem

Datasource column name change

Change gateway datasource

Deployment pipeline not detecting report changes