topic Change Datasource In report in Report Server

Change Datasource In report

hervema — Fri, 14 Feb 2020 11:15:12 GMT

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é

Re: Change Datasource In report

bradsy — Fri, 14 Feb 2020 21:38:48 GMT

Manage\Data Sources on the report.

Re: Change Datasource In report

hervema — Fri, 14 Feb 2020 21:54:04 GMT

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) 😞

Re: Change Datasource In report

Flynn — Wed, 15 Apr 2020 10:53:09 GMT

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

Re: Change Datasource In report

Anonymous — Wed, 15 Apr 2020 11:43:35 GMT

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.