Forum Discussion
Troubleshooting Gateway
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.
Anonymous thank you
Unfortunately, that did not fix the situation.
At this point, I am unsure as to whether it is actually possible to do what I am doing.
When I read this thread or this one, it seems it is not possible. It seems the dataset can only contact 1 gateway. It does not matter if the additional gateways are on the same cluster.
As it stands, it seems I must have 1 cluster for each single gateway installed on each single SQL server. Then, I can refresh each dataset from each SQL server, but only individually. Which prevents me from building a worldwide reports and restricts me to a continental report.
So, the question, is it possible to refresh a dataset with data coming through different gateways, assigned to the same cluster?