ODBC Error in Data Gateway Connection

[Sashwato]

Hello All,

I am running into a strange data gateway connection issue and it doesn't let us add the data point to the gateway. I have added the screenshot below for further information. The client has setup a on-premise data gateway with enterprise mode. Can someone help/suggest any solution for this?

Any help would be appreciated!

Regards!

[Anonymous]

Hi  @Sashwato ,

The 400 ERROR means a bad http request. Please updata on-premise gateway to the lastest version.

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-update

Then you can refer to steps below for troubleshooting.

https://community.powerbi.com/t5/Service/We-could-not-register-this-data-source-for-any-gateway-inst...

Or the ODBC Driver Manager cannot find the driver you specified in the connection string or DSN. You can check the following URL to view related content:

https://docs.microsoft.com/en-us/answers/questions/227987/34error-im002-microsoftodbc-driver-manager...

https://stackoverflow.com/questions/58571740/why-am-i-getting-data-source-name-not-found-and-no-defa...

https://community.powerbi.com/t5/Power-Query/ODBC-Error-Data-source-name-not-found-and-no-default-dr...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.