Same db, 2 ips - gateway manipulation possible?

[NovaBI]

Hi all,

as our "old" dataware house server is sometimes heavily loaded (month end e.g.), we have created an image of the old server and created a new virtual machine.

Everything is fine, I can connect to both machines (only difference are the last 3 digits of the ip) in PBI Desktop. If i change the ip-adress in the advanced editor, everything is fine. I can refresh.

But if I publish a report that is based on the standard log in to the server into the PBI Service, the new gateway i set up is complaing that the status "is not configured correctly". Cause the gateway is expecting e.g. .123 but the report was done with server ip .345. 

Is there a way to solve this or do we need to change the ip everytime a report is loaded for the 1st time? 

Using the "old" server as a standard approach is not possible. 

[nitishsh91]

Hi @NovaBI 

You can create a parametrised report using variables and can select the datasource that you want to use from parameter option before refreshing the report.

[NovaBI]

Hi @nitishsh91 ,

thanks for your answer. That could be reasonable. Have you any kind of link to get me started?

[nitishsh91 · Accepted solution]

Hi @NovaBI 

Try below link:

https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters