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

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.