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

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