Power BI Desktop - Cloudera Kerberos authentication Impala

[Anonymous]

Hi,

I am facing the issue while trying Impala as Get Data from Impala, it says some certificate issue.

Power BI Desktop - Version: 2.67.5404.981 64-bit (March 2019)

Impala - CHD' Impala Kerberos authentication

Error:

"ERROR [HY000] [Microsoft][DriverSupport] (1100) SSL certificate verification failed because the certificate is missing or incorrect"

As per my understanding, Microsoft built in ODBC driver not able to handshake properly with Impala.

What I mean here Microsoft built in ODBC driver'  have their own *.pem file however Impala have their own *.pem file.

To understand in more detailed I also enable trace for Power BI Desktop 

If you read below log out it is very clearly mentioned that 

"ERROR [HY000] [Microsoft][DriverSupport] (1100) SSL certificate verification failed because the certificate is missing or incorrect"

So please advise how we can specify Impala' PEM file to Microsoft ODBC built-in driver to use for authenticating to the client.

Please also note that   I have a local certificate which available to my desktop.

Just for courtesy, I installed the latest version on Power BI Desktop to fresh Virtual Machine, but same error also there.

It's highly appreciated for helping here.

Thanks.

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.

[v-piga-msft]

Hi  @Anonymous ,

It seems that when we get data from Impala, the Impala connector supports Anonymous, Basic (user name + password), and Windows authentication.

Which one do you select?

In addition, could you add your impala data source in on-premises data gateway in Power BI Service, if you could add it in the gateway, you could use the same crendential in Power BI Desktop to get the data.

Best Regards,

Cherry

[Anonymous]

Hi @v-piga-msft 

I am using Windows authentication.

As per your below comments,

In addition, could you add your impala data source in on-premises data gateway in Power BI Service, if you could add it in the gateway, you could use the same crendential in Power BI Desktop to get the data.

Correct my understanding, i need to follow below steps,

I need MIT Kerberos to get credential from the Impala server

configure the data source 

then go for testing using power bi

Thanks