- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, I'm found same problem now. I use impala connect to hadoop via power bi. Please advice me thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
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.
Subject | Author | Posted | |
---|---|---|---|
07-14-2024 05:23 AM | |||
Anonymous
| 04-27-2021 12:24 AM | ||
09-30-2024 09:20 AM | |||
05-16-2024 06:44 AM | |||
07-30-2024 06:39 PM |