Power BI multiple gateway

[YashikaAgrawal]

Hi,

Working on creating a Power BI gateway on Virtual machine.
SQL server and Oracle, needs to be connected.
Can we create or install two gateway, join them as a cluster so that if one of them goes down the other one will still function.

Can someone please explain how to do this.

Thanks,

Naveen

[v-saisrao-msft]

Hi @YashikaAgrawal,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

Thank you.

[sergej_og · Accepted solution]

Hey @YashikaAgrawal ,
check the box in the gateway setting in Service.

Service will take care of request distribution.

Consider enough RAM and CPU according to your needs.
If you don't know how much is needed monitor your VM utilization when the heavy loads are running...then you will (most likely) know.

Regards

[v-saisrao-msft]

Hi @YashikaAgrawal,

You can set up multiple On-premises Data Gateways on different virtual machines and configure them as a gateway cluster. This setup ensures high availability, supports failover, and helps avoid single points of failure by balancing the load across gateways.

Manage on-premises data gateway high-availability clusters and load balancing | Microsoft Learn

Power BI implementation planning: Data gateways - Power BI | Microsoft Learn

Power BI high availability, failover, and disaster recovery FAQ - Microsoft Fabric | Microsoft Learn

Thank you.