Forum Discussion
Power BI Reports Connection String change on Power BI Report Server using Rest API
Hi, I am trying to publish Power BI Reports to Power BI Report Server in different environment like Dev, SIT, Prod through PowerShell Script using Rest API. While publishing, I am changing the PB...
Plantje
Helper I
Helper II have found another work around.
If you edit the C:\Windows\System32\drivers\etc\hosts\file file (correct, no extension)
And add something like this:
[IP of your SQL Server DB] SQLServer
Then you can do that on all your application servers and in the report you can use "SQLServer" as server name. Then you can deploy the reports without editting them.
Thanks,
In my case, need to change both database and server name in all environments.
- Plantje
Ah ok, that will be harder. Microsoft should just do an update :)
I tried to change host file but change only reflects when you restart the powerBI report server- I tried with host file and found that host file change only works if we restart the power bi report server after host file changed
- Plantje
Oops, sorry, forgot to mention that!