Forum Discussion

srv123's avatar
srv123
New Member
7 years ago

Gateway issue

Hi all,   I`m having issues with scheduled refresh on a report published from an exxternal desktop. The data consists of 3 sources.    The error I am getting is the following: "Gateway on endpoi...
Need Help
srv123's avatar
srv123
New Member
7 years ago

So, 2 of the data sources seems fine when pressing "play" on the gateway on powerbi.com. 

Source number 3 has this error, when trying to add it to the list:

 

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI srv123,

     

    Is there any advanced options in your query?(append, combine, merge, reference other query, invoke custom functions...)

     

    Can you please provide more detail informations about your scenario?(datasource type, connection mode, detail error message, gateway log, refresh history)

     

    BTW, you can also take a look at support page, if you are facing known issues which list on support page.

     

    Regards,
    Xiaoxin Sheng

    • srv123's avatar
      srv123
      New Member
      7 years ago

      Hello,

       

      There are no advanced options in the query. The source is a SQL database, and the data is fetched through a procedure. 

      When trying to add the connection this error is recieved:

       

      "Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details
      Activity ID: b1edce2c-c83f-695a-eee2-b0aeb2f4fba6
      Request ID: 873a47af-3dc8-5048-6161-ac25a6c952de
      Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net
      Status code: 400
      Error Code: DMTS_PublishDatasourceToClusterErrorCode
      Time: Thu Sep 13 2018 09:18:22 GMT+0200 (Central European Summer Time)
      Version: 13.0.6700.151
      CLD-191: The gateway is either offline or could not be reached.
      Troubleshoot connection problems"

       

      Thank you!

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi srv123,

         

        Do you mean you are using power bi to invoke sql stored procedure to get data, right? Which connection mode you used?

        If you mean directquery, current power bi not support to invoke stored procedure in directquery mode.

         

        Regards,

        Xiaoxin Sheng