Cloudera Impala kerberos authentication with Power BI report server

[AvinashPentyala]

Dear Team,

Could you please suggest the best way to connect from Power BI Desktop and Report Server to a Kerberos-enabled Cloudera Hive DB using Impala? Kindly share any reference links or documents.

Thanks!

[v-pnaroju-msft]

Hi AvinashPentyala,

We are following up to check if your query has been resolved. If you have found a solution, kindly share it with the community to help others facing similar issues.

If our response was helpful, please mark it as the accepted solution. This will benefit the wider community.

Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi AvinashPentyala,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[v-pnaroju-msft]

Hi AvinashPentyala,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft]

Hi AvinashPentyala,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[v-pnaroju-msft]

Hi AvinashPentyala,

Thank you for your detailed query and the update.

Based on my understanding, your successful DSN test indicates that the Impala ODBC connection with Kerberos is functioning correctly at the local level. The issue with Power BI Report Server is most likely due to missing Kerberos delegation or improper configuration at the server or service level.

Kindly follow the steps below which may help in resolving the issue:

1. Ensure that the krb5.ini file is configured at C:\ProgramData\MIT\Kerberos5\krb5.ini with the correct realm and KDC settings.
2. Use a domain account for the Report Server service instead of the LocalSystem account.
3. In Active Directory, configure the service account for "Trust this user for delegation to specified services only" and add SPNs for impala/your-hostname.
4. Obtain a Kerberos ticket on the server by executing:
   kinit yourserviceaccount@YOUR.REALM.COM
5. Use the following connection string in the Report Server data source:
   DSN=YourDSN;AuthMech=1;KrbRealm=YOUR.REALM.COM;KrbHostFQDN=impala.yourdomain.com;KrbServiceName=impala;
6. Verify that the Cloudera driver is installed on the server and that the DSN is configured as a System DSN.

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other members of the community facing similar queries.

Should you have any further questions, please feel free to contact the Microsoft Fabric community.

Thank you.

[Maverik91]

Same here.....

[Anonymous]

Hi, @AvinashPentyala 

Maybe you can check the following links:

How to Connect to Impala Using the Power BI Deskto... - Cloudera Community - 392770

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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

[AvinashPentyala]

Hi, 

I installed MIT Kerberos on the Power BI server machine (Windows) and created a system DSN.
The test connection works from the DSN, but after deploying to the Power BI Report Server, the test connection returns the following error at Data source in report server.
Could you please assist?

Couldn't connect
The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.

Hide error details
ODBC: ERROR [HY000] [Cloudera][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct.
ERROR [HY000] [Cloudera][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct.