how to change gateway connection

[adnankabina]

Hi everyone, 

I have workspace that contains more than 100 reports. I have two different connection based on two different gateway. Gateway A is connected to one server and gateway B is connected to another server. 

sometimes gateway A does not work properly and most of reports connection fail. Is possible to to change it to another gateway B without downloading file on PBI services. 

your help is appreiated. 

[SaiTejaTalasila · Accepted solution]

Hi,

You can refer this -

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-high-availability-cluster...

[v-yohua-msft]

Hi, @adnankabina 

Thanks for the reply from @lbendlin , please allow me to provide addition:

First, identify all datasets in your workspace that are currently using Gateway A. You can do this by navigating to the dataset settings in the Power BI service.

For each dataset that uses Gateway A, you need to change the connection to Gateway B. To do this, you'll need to go to Dataset settings in the Power BI service.
Under the Gateway Connections section, you should see the option to change the gateway. Select Gateway B from the list of available gateways.
If Gateway B requires different credentials, make sure to update them accordingly. You can do this under the Data Source Credentials section of the dataset settings.

You can check the following links:

Add or remove a gateway data source - Power BI | Microsoft Learn

Configure proxy settings for the on-premises data gateway | Microsoft Learn

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Datasets - Bind To Gateway In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn