Direct Query to Cloudera Impala/Hive in Power BI Desktop

[Anonymous]

Hi,

I have a Cloudera Hadoop Cluster with Kerberos Authentication. I want to do DirectQuery on Impala(preferred)/Hive.

Can anyone share the details if anyone has successfully established connectivity between Power BI and Impala?

Currently, I get error SSL authentication failed. I have a certificate file but I could not find an option to specify its value anywhere.

Is there any other way to establish DirectQuery Connectivity between Impala/Hive and Power BI maybe by using some other connector?

Would really appreciate any pointers.

Thanks.

[v-lionel-msft]

Hi @Anonymous ,

Has your problem been solved?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Lionel,

Thanks for your reply.

I had a few queries.
The solution is using Impala Connector. And our Impala server is using kerberos authentication with a certificate but there is no option to specify that with Impala Connector. So I was wondering if I am missing anything?

[v-lionel-msft]

Hi @Anonymous ,

I found a post with the same problem, please refer to the solution.

Unable to Connect Power BI to Impala connector 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lionel-msft]

Hi @Anonymous ,

Maybe you can use the Impala connector of Power BI Desktop directly.

Connect to an Impala database in Power BI Desktop 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @v-lionel-msft ,

When I am using the Impala Connector of Power BI Desktop it gives below error.

So wanted to check how the community is connecting to Impala.

[amitchandak]

@Anonymous , make sure you have installed the SSL certificate. refer these stesp

https://support.securly.com/hc/en-us/articles/360026808753-How-to-manually-install-the-Securly-SSL-certificate-on-Windows

[Anonymous]

Hi Amit,

Thanks for your inputs but it didn't work.

I have a .pem file which we are using for Authentication in ODBC DSN connection to Cloudera Impala.

But as I mentioned I am looking for Direct Query connectivity to Cloudera Impala/Hive.