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

Impala - Failed to update data source credentials

This is the error I got trying to refresh data from Impala.

 

Failed to update data source credentials: ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (0) Failed to initialize SASL client library: generic failureHide details

 

Connection by Desktop works but the problem is with refreshing data from Service.

Doesn’t work on both personal or enterprise gateway

I use basic authorization mode.

 

Appreciate any suggestions

6 REPLIES 6
Moderator v-yuezhe-msft
Moderator

Re: Impala - Failed to update data source credentials

@Gordon2,

What version of Power BI Desktop and Power BI gateway do you use? Are you able to refresh data in Power BI Desktop?

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.
Gordon2 Member
Member

Re: Impala - Failed to update data source credentials

Yes, in Power BI Desktop get data from Impala works.

Let me check the versions. In the mean time.

Should I have installed ODBC drivers for Impala?

 

Moderator v-yuezhe-msft
Moderator

Re: Impala - Failed to update data source credentials

@Gordon2 ,

If you use  the built-in Impala connector in Power BI Desktop, you don't need to install ODBC driver.

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: Impala - Failed to update data source credentials

Hi,

 

I am also facing the same issue while trying Impala as Get Data, som certificate issue coming.

 

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

Impala - CHD' Impala Kerberos authentication

 

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

 

 

 

Gordon2 Member
Member

Re: Impala - Failed to update data source credentials

Based on my last experience Power BI build in drivers for Impala doesn't work. Alternatively, you download Cloudera ODBC drivers from their site and use ODBC connection in get data in Power BI, then you will be able to use these drivers.
Disadvantage of this is you cannot use direct query. ODBC doesn’t allow for this. So, if I have terabytes of data I am not able to use Impala with PBI. At this moment I do not have solution for this.

Gordon2 Member
Member

Re: Impala - Failed to update data source credentials

@wwwnlc111 

As far SSL error. Have you get encrypt connection unchecked?:

w2.PNG