Forum Discussion

oakgogo's avatar
oakgogo
Icon for Helper II rankHelper II
2 years ago
Solved

Is it possible to switch this to Database Server 2 in service gateway?

After a Power BI Desktop report is published to the service, the previously configured gateway maps to Database Server 1. Is it possible to switch this to Database Server 2 in service gateway? both 2 database servers and gateway buit in same server

Need Help
Show and Tell
  • lbendlin's avatar
    lbendlin
    2 years ago

    You cannot switch servers in Power Query. What you can do - if your credentials allow it - is to switch between databases on the same server.

     

    Gateway connections cannot be modified in the Gateway Management UI.  If your data source changes you need to start over and create a new connection.

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    You cannot switch servers in Power Query. What you can do - if your credentials allow it - is to switch between databases on the same server.

     

    Gateway connections cannot be modified in the Gateway Management UI.  If your data source changes you need to start over and create a new connection.