cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
benabda Frequent Visitor
Frequent Visitor

Power BI Impala connection

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.

====

Screen Shot 2019-01-16 at 12.32.46.png

3 REPLIES 3
Community Support Team
Community Support Team

Re: Power BI Impala connection

@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 Frequent Visitor
Frequent Visitor

Re: Power BI Impala connection

 @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.

 

JonathanR Frequent Visitor
Frequent Visitor

Re: Power BI Impala connection

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

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)