Power BI Impala connection

[benabda]

Hi,

i am using cloudera impala with sentry enabled.

When i would like to connect my power bi to impala db, i have this error:

How i can set UseSasl to 0 or to change parameters configs?

====

[Microsoft][ThriftExtension] (3) Error occurred while contacting server: ETIMEDOUT. The connection has been configured to use a SASL mechanism for authentication. This error might be due to the server is not using SASL for authentication.

====

[v-yuta-msft]

@benabda,

As the error message said, you should configure SASL for authentication in impala db. This can be resolved easily by clicking Ok on the error and at the connection Information window uncheck the 'Use Simple Authentication and Security Layer(SASL)' option. For more detail about how to resolve this issue, you may refer to this blog: http://discoverbi.blogspot.com/2015/12/solved-impala-odbc-sasl-authentication-error.html.

Regards,

Jimmy Tao

[benabda]

 @v-yuta-msft I am using the impala connector (https://docs.microsoft.com/en-us/power-bi/desktop-connect-impala) not ODBC. I don't have OK button (just Back, Connect or Cancel), when i click Connect, nothing change and i still have the same error.

The link that you mentionned is about using odbc connector to import impala db.

[Anonymous]

Hi, I have the same error, you managed to solve it, regards