Forum Discussion

EVEAdmin's avatar
EVEAdmin
Post Patron
7 years ago

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...
Need Help
EVEAdmin's avatar
EVEAdmin
Post Patron
7 years ago

Can't go past the current situation.

 

If I install the gateway on each server and I use the same cluster, refreshiing the dataset, from 3 sources, will fail.

If I install the gateway on each server and create a new cluster for each server, refresh will also fail.

 

It will only work when I run the query runs on a single data source. From the example above, I can refresh data that come only from Server 1 or Server 2 or Server 3. 

If the dataset runs queries on different servers, then it fails, no matter what.

Any clue? 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.

  • EVEAdmin's avatar
    EVEAdmin
    Post Patron
    7 years ago
    Thankyou, I did not complete that step, indeed. Will try soon. Will that work even if each SQL instance is on a different server?
  • EVEAdmin's avatar
    EVEAdmin
    Post Patron
    7 years ago

    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?