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 working properly. Everything is fine, so far.

 

The question is: how do I need to install the gateway on Server 3 and Server 4? Shall I add them to the same cluster A? or each gateway to its own cluster? 

Thank you.

 

Need Help

9 Replies

  • 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.

    • v-diye-msft's avatar
      v-diye-msft
      Community Support
      7 years ago

      Hi EVEAdmin ,

       

      No need to create new cluster for them, you can put them under same cluster.

      After addind them to data source setting in gateway, could you plz make sure the it prompts "Connection succesfully"?

      • EVEAdmin's avatar
        EVEAdmin
        Post Patron
        7 years ago

        v-diye-msft thank you

        That is what I did. I first put each gateway under the same cluster. 

        After I add the datasource details, it does say Connection Successful along with a message that say it could not connect to the datasource. The error details refer to something similar to the following

        Cluster URI:WABI-NORTH-EUROPE-redirect.analysis.windows.net
        Activity ID:4c600672-dd5f-429c-8eb0-5bb5e1f48f43
        Request ID:8d86151f-5f22-4f09-9096-01ba68477466
        Time:2018-07-28 09:31:21Z