Forum Discussion

deepaknkin's avatar
deepaknkin
New Member
8 years ago

ODBC Connection error Gateway server

Hi,   I am trying to create a ODBC data source for Oracle and SNOWFLAKE on the Gateway server and i am getting following error   I have created ODBC connection in 64 bit DSN on the gateway server...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi deepaknkin,

 

I can't reproduce your issue, ODBC still works on my side.

Which source is your ODBC connecting to? Does this source works properly in Power BI Desktop but not for service?

If so, please verify your datasource settings first.(connection string, authentication type and credential)

 

BTW, 400 error code also means to your request cannot access to correspond datasource.

The 400 Bad Request error is an HTTP status code that means that the request you sent to the website server, often something simple like a request to load a web page, was somehow incorrect or corrupted and the server couldn't understand it.

 

Regards,

Xiaoxin Sheng

  • samwils's avatar
    samwils
    New Member
    8 years ago

    I am also hitting the same problem.

     

    Unable to connect: We encountered an error while trying to connect to https://cosmos15.osdinfra.net/cosmos/asimov.partner.osg. Details: "We could not register this data source for all gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details

    Activity ID:837e7f27-e514-43e1-81f5-0dae288b2ff8
    Request ID:0a354a6f-484f-35f4-904b-63f381f2949c
    Cluster URI:https://df-msit-scus-redirect.analysis.windows.net
    Status code:400
    Error Code:DMTS_PublishDatasourceToClusterErrorCode
    Time:Mon Jan 22 2018 18:57:48 GMT-0800 (Pacific Standard Time)
    Version:13.0.4063.162
    samwils_gateway:The format of the connection details is invalid.
    Troubleshoot connection problems
     
    The troubleshoot connection problems link returns 404.
     
    I verified the connection string, https://cosmos15.osdinfra.net/cosmos/asimov.partner.osg, works on my side.
    I have also tried all kinds of authentications which has the same result.
    How can I debug this issue?
     
    Best regards,
    Sam