ODBC Connection error Gateway server

[deepaknkin]

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, but even then I am getting this error

 

Activity ID:	a4982c99-c917-4526-a4e5-d45fb8e2a902
Request ID:	b135e31c-5338-2d1a-1a36-a1b1592268a9
Cluster URI:	https://wabi-us-east2-redirect.analysis.windows.net
Status code:	400
Error Code:	DMTS_PublishDatasourceToClusterErrorCode
Time:	Thu Jan 11 2018 00:02:10 GMT-0500 (Eastern Standard Time)
Version:	13.0.3847.150

Dee_TEST:

The format of the connection details is invalid.

[Anonymous]

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]

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