Forum Discussion
Best Practices for Gateway
I have been reading from these two articles on the best practices of installing and sizing gateways.
https://learn.microsoft.com/en-us/power-bi/guidance/gateway-onprem-sizing
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-deployment-guidance
Can you share what is the best practices in your gateway? Do you have one or multiple for you company? When should I install a second one? The article said to install one for each report. Really?
Hi LiquidMetal ,
The best practices in the gateway:
- You can use an on-premises data gateway cluster to avoid single points of failure and to load balance traffic across gateways in a cluster.
Do you have one or multiple for you company:
- Yes, we need to do some tests.
When should I install a second one?
-
You can create high-availability clusters of gateway installations. The clusters help ensure that your organization can access on-premises data resources from cloud services like Power BI and Power Apps. Gateway admins use such clusters to avoid single points of failure when accessing on-premises data resources.
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.
The article said to install one for each report. Really?
- What this means is that you can configure the gateway for each report, which can be the same gateway. But if that gateway fails there will be problems such as refresh failures, so you can avoid single points of failure if you enable gateway clustering.
- You can choose to let traffic be distributed evenly across gateways in a cluster. By default, the selection of a gateway during load balancing—that is, when "Distribute requests across all active gateways in this cluster" is enabled—is random. You can change this setting to distribute the load.
More details:Manage on-premises data gateway high-availability clusters and load balancing | Microsoft Learn
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi LiquidMetal ,
The best practices in the gateway:
- You can use an on-premises data gateway cluster to avoid single points of failure and to load balance traffic across gateways in a cluster.
Do you have one or multiple for you company:
- Yes, we need to do some tests.
When should I install a second one?
-
You can create high-availability clusters of gateway installations. The clusters help ensure that your organization can access on-premises data resources from cloud services like Power BI and Power Apps. Gateway admins use such clusters to avoid single points of failure when accessing on-premises data resources.
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.
The article said to install one for each report. Really?
- What this means is that you can configure the gateway for each report, which can be the same gateway. But if that gateway fails there will be problems such as refresh failures, so you can avoid single points of failure if you enable gateway clustering.
- You can choose to let traffic be distributed evenly across gateways in a cluster. By default, the selection of a gateway during load balancing—that is, when "Distribute requests across all active gateways in this cluster" is enabled—is random. You can change this setting to distribute the load.
More details:Manage on-premises data gateway high-availability clusters and load balancing | Microsoft Learn
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.