Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Hive table not getting loaded on power bi desktop

Hi Team,

 

While loading a table from hive, i am encountering the below error. Thanks for your help in advance!

 

aniketvals_0-1640793225674.png

 

1 REPLY 1
v-yalanwu-msft
Community Support
Community Support

Hi, @Anonymous ;

1.Please check if the credentials are correct? For example, server address, port and password, etc.

 you can installed the new version to check whether it works.

 

2.The error "Invalid Operation Handle" is generally caused by a misconfiguration which interferes with the communication between Tableau and the database. 
For example:

  • Load balancer configuration (Test this by connecting directly to the Cloudera node, bypassing the load balancer)
  • Kerberos authentication issues
  • Network Issues

3.checked all the steps in the query editor in case any of them gives an error? 
https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-DataSource-Error-MySQL-Fatal-error/m-p/512516

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.