Forum Discussion

hervema's avatar
hervema
Microsoft Employee
6 years ago

Change Datasource In report

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 product...
PBI Report Server Datasource
Flynn's avatar
Flynn
Frequent Visitor
6 years ago

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

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.