Reply
manojkumarvohra
New Member
Partially syndicated - Outbound

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

Syndicated - Outbound

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

Syndicated - Outbound

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

Syndicated - Outbound

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

Syndicated - Outbound

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.
avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)