Impala kerberos Direct Query

[manojkumarvohra]

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.

[fabiothomaz]

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]

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

[v-yuezhe-msft · Accepted solution]

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