Multiple Gateway on one Power BI Report

[sherry0812]

Hello,

Scenario:
I have a report which has an on-prem data connection and to set up scheduled refresh for the report, I installed a gateway in server 1.

Now I want to set up another gateway as a backup installed in server 2.
So that scheduled refresh will not be affected, in case server 1 fails.

Is it possible to use multiple gateways for one report?

Thank you.

[v-xicai]

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

[reportsgroup]

Hi @v-xicai @sherry0812 

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.

[sherry0812]

Yes. Thank you.

[v-xicai · Accepted solution]

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.