cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DataGuyJim New Member
New Member

Started getting this error for the PowerBI Impala and ODBC Connector.

Started getting this error for the PowerBI Impala and ODBC Connector:

 

Details: "ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1160) Cannot enable SSL for the connection when connecting to a server that has not enabled SSL. If the server has SSL enabled, please check if it has been configured to use a SSL protocol version that is lower than what is allowed for the connection. The minimum SSL protocol version allowed for the connection is: TLS 1.2."

 

is this a permissions issue?  Or does the IT at my organization need the "minimum SSL protocol" of TLS 1.2?

2 REPLIES 2
Moderator v-yuezhe-msft
Moderator

Re: Started getting this error for the PowerBI Impala and ODBC Connector.

@DataGuyJim,

What version of Power BI Desktop do you use? Please update your Power BI Desktop to latest version( 2.66.5376.1681).

In addition, do you configure SSL for the Impala server? If so, ensure that the SSL protocol version is lower than TLS 1.2.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
wwwnlc111 Frequent Visitor
Frequent Visitor

Re: Started getting this error for the PowerBI Impala and ODBC Connector.

@v-yuezhe-msft  

Still I am facing the same issue

 

From the Power BI Desktop' log it seems some certificate issue with the inbuild-odbc driver for Impala 

Please help on this

 

DataMashup.Trace Error: 24579 : {"Start":"2019-04-04T11:28:44.5688920Z","Action":"Engine/IO/Db/ODBC/RunWithRetryAttempt","HostProcessId":"10924","Attempt":"0","MaxAttempt":"3","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: ERROR [HY000] [Microsoft][DriverSupport] (1100) SSL certificate verification failed because the certificate is missing or incorrect.\r\nStackTrace:\n   at Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcUtils.HandleError(OdbcHandle hrHandle, RetCode retcode)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcConnectionHandle..ctor(IOdbcInterop odbcInterop, OdbcEnvironmentHandle environmentHandle, String connectionString, Nullable`1 connectionTimeout)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcService.OdbcEngineConnection.Open()\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcImpersonatingService.ImpersonatingConnection.Open()\r\n   at

 

Thanks