Change Datasource In report

[hervema]

Hello,

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...

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.

How to do it?

Thanks,

Regards,

Hervé

[bradsy]

Manage\Data Sources on the report.

[hervema]

 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]

Hi all,

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\hosts
Use the same alias with different hosts in every environment and use this alias in the Power BI Report.

Best Regards

[JeanMartinL]

This is indeed very annoying.

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.

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.