On premises Gateway and High Availability Setup.

[dpohane]

Hello,

    I have two servers connecting to the same On Premises Gateway Cluster using the same service account. This being in the same cluster, I tried running some tests to see how cluster will behave when one of the servers goes down. For continuity (High availability) sake I want to take all steps that will make sure PowerBI Reports  won't  fail even if one of the gateway servers goes down. I have following two questions:

   1. How to force Secondary Gateway Server to be Primary? I tried "Migrate, restore, or take over", this option is not always available when I shut down service/server on Primary end. It was available only once when I shut down Primary. After that I tried to reproduce the scenario again but it didn't work.

   2.  How to automate the entire High Availability? If Primary Goes down, how do we make secondary to be primary automatically without manual intervention. 

Thank you

Dinesh Pohane

[v-lionel-msft]

Hi @dpohane ,

What you want to do is to automatically set other gateways as the primary gateway when the primary gateway is broken?
This idea has not yet been realized. Maybe you can submit your idea .
But I don't think it is necessary to do this. When the primary gateway is broken, the dataset will be automatically refreshed through other available gateways in the cluster.

Best regards,
Lionel Chen

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

[dpohane]

Hi Lionel,

   I tried shutting down primary to see if other server in a cluster can pick up traffic. It failed. I was not able to run any reports. 

Dinesh.