How many gateways are needed

[nshama]

Hi All,

We have about 200 reports in SSRS, which we are migrating to Power BI and we want to setup scheduled refresh as well as subscriptions to these reports. Could you please suggest how many gateways are required for 200 reports or one gateway is enough for all the reports.

Also, do we need high availability?

Please suggest 

Thanks in Advance,

Neelofar.

[Anonymous · Accepted solution]

Hi @nshama ,

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:Manage on-premises data gateway high-availability clusters and load balancing | Microsoft Docs

If I have misunderstand your meaning, please provide more details.

Best Regards

Community Support Team _ Polly

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

[truptis]

Hi @nshama ,

In power bi we have a constraint of having one gateway per report. 

Refer this article if you need some additional information:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-deployment-guidance

@nshama  @If this helps you then please hit the thumbs up and mark it as a solution. Thanks