Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
manojkumarvohra
New Member

Impala kerberos Direct Query

Hi,

 

We are trying to establish a direct connection with our Impala server.

 

We have initailised our Kerberos TGT on windows.

 

We tried connecting with our deamonhost:21050 but its giving below error:

[Microsoft][ThriftExtension] (5) Error occurred while contacting server: No more data to read.. This could be because you are trying to establish a non-SSL connection to a SSL-enabled server.

 

Can you please guide what could be the issue here?

We have not enabled SSL on our server.

 

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

Hi @manojkumarvohra,

Based on this official article,  Anonymous and UserName/Password credentials  are supported when connecting to Impala server in Power BI Desktop. 

Kerberos authentication is not supported yet, an idea about this issue has been submitted in the following link, please vote it up to get this feature prioritized. In your scenario, please use Anonymous or UserName/Password credential to connect to Impala server on DirectQuery mode, and check if it is successful.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15949948-support-kerberos-authent...

Thanks,
Lydia Zhang

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.

View solution in original post

3 REPLIES 3
fabiothomaz
New Member

While the support for DirectQuery in a Kerberos enabled environment isn't released, you can configure your Impala service to authenticate with LDAP.
The impala service will use the authenticated LDAP user for authorization (sentry) and the impala service principal to access the cluster resources.
With this configuration, we're able to use PBI DirectQuery + Impala + Kerberos.

You can find more about Impala LDAP authentication at:
https://www.cloudera.com/documentation/enterprise/latest/topics/impala_ldap.html

Regards,
Fabio Thomaz

nottp106
New Member

Capture.PNGHi, I'm found same problem now. I use impala connect to hadoop via power bi. Please advice me thank you.

 

 

v-yuezhe-msft
Microsoft Employee
Microsoft Employee

Hi @manojkumarvohra,

Based on this official article,  Anonymous and UserName/Password credentials  are supported when connecting to Impala server in Power BI Desktop. 

Kerberos authentication is not supported yet, an idea about this issue has been submitted in the following link, please vote it up to get this feature prioritized. In your scenario, please use Anonymous or UserName/Password credential to connect to Impala server on DirectQuery mode, and check if it is successful.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15949948-support-kerberos-authent...

Thanks,
Lydia Zhang

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors