Forum Discussion
Troubleshooting Gateway
On PBI desktop, I built a report that contacts 3 different SQL Servers: Server 2 Server 3 Server 4 Server 2 is already running the "on premises Gateway", in the cluster A. Data refresh is worki...
Did you do this? You should use the same cluster on all 3 boxes.
Load balance across gateways in a cluster
You can choose to let traffic be distributed evenly across gateways in a cluster. By default, the selection of a gateway during load balancing is random.
For example, to provide load balancing from the Power BI service, select the gear icon in the upper-right corner, then select Manage gateways. Next, select Distribute requests across all active gateways in this cluster.
This will allow you to use any of the 3 then to refresh.
Thankyou, I did not complete that step, indeed. Will try soon. Will that work even if each SQL instance is on a different server?