Forum Discussion
Multiple Gateway on one Power BI Report
Hi sherry0812 ,
You can create high availability clusters of On-premises data gateway installations .The Power BI service always uses the primary gateway in the cluster, unless it’s not available. In that case, the service switches to the next gateway in the cluster, and so on.
You can see how to create gateway cluster: https://docs.microsoft.com/en-us/power-bi/service-gateway-high-availability-clusters , https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi sherry0812 ,
Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
regarding this issue, would it be better to have multiple individual gateway for multiple reports scheduled refresh? or a gateway cluster to handle all of those reports?
in parallel or series
parallel. multiple individual gateway. example : 6 powerbi report having their scheduled refresh. split it accordingly to 3 gateway, 2 each. it seems to be a good idea to split them, but issue if either one of them is inactive, 2 is considered as failure already.
series. cluster gateway. 3 gateway in one cluster. my worry would be the 6 report would overload the primary gateway, or if primary is inactive, overload the second one or and so forth to last gateway. or would they be spread out accordingly? each gateway takeup one scheduled refresh in a step down flow, and the other 3 queue up behind them.
please let me know your opinion on this or suggestion
we are runnnig multiple scheduled refresh on one office gateway, with multiple errors happening.
gateway on refresh.
gateway memory issue. counldnt access datasource because of it.
inactive gateway
so we are looking toward solving it through the above approach. thank you for the help.