I have configured a Power BI Gateway Cluster with a primary and secondary gateway and I have enabled the option to distribute requests across all active gateways in the cluster. When the primary gateway is offline (service stopped or server offline), scheduled and manual refreshes of datasets do not work.
I've confirmed connectivity to all data sources and all service urls on the secondary gateway. The refreshes and connection tests work fine, even if the primary gateway is offline, but refreshes do not work (error: The gateway is either offline or could not be reached.).
The documentation states:
"The gateway cloud service always uses the primary gateway in a cluster unless that gateway isn't available. In that case, the service switches to the next available gateway in the cluster."
and ""It is recommended to disable or remove an offline gateway member in the cluster. If a gateway member is offline instead of disabled or removed, we may try to excecute a query on that offline member, before moving to the next one. This can negatively impact the performance."
which suggests that this should work even if the primary is offline, but it does not. Has anyone seen this before, or have info on what might be causing these refreshes to fail?
