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? 

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
    • v-diye-msft's avatar
      v-diye-msft
      Community Support
      7 years ago

      Hi EVEAdmin ,

       

      There's only one gateway works in one time (unless On-premise and Personal ), did you put all the source info under same gateway? rather than different gateways?

       

      • EVEAdmin's avatar
        EVEAdmin
        Post Patron
        7 years ago

        v-diye-msft thank you again.

        I just installed again the gateway, not in personal mode, on SERVER03. The gateway has been added to the Cluster created with the primary account, installed on SERVER02.
        I also added the datasources and mapped them again the gateway.

        Everything looks fine.

         

        HOwever, when I test the datasource connection, I get the error below, where basically the Server03 data settings cannot establish connection to the Server02:

         

        Finally, if I try and refresh the dataset, I get the error below.

        Error 40 is what SQL will throw when you cannot login.

         


         

        If I install each gateway in its own cluster, it all works. BUt, I cannot build a report that grabs data from each SQL of those SQL servers.
        I'd be very happy to find out what I am doing wrong.