connecting power bi to hive database

[sreekar09]

I cannot see Hive as a listed data source in power BI . Is there a way to connect Hive database with power bi desktop, also is there any limitation?

 I gone through below link,Is there any other way to do  it other than connecting to ODBC driver

https://community.hortonworks.com/articles/61185/visualizing-hive-data-using-microsoft-power-bi.html | Hadoop Big data

[v-lid-msft]

Hi @sreekar09 ,

Sorry for that, Based on my research, but I also not found an effective solution to connect Hive database without using ODBC Drivers, if you want to know how to connect with ODBC Drivers, you can get the steps from this document: https://docs.microsoft.com/en-us/azure/hdinsight/hadoop/apache-hadoop-connect-hive-power-bi. The main Limitation is  ODBC driver does not support DirectQuery.

Perhaps you can review the following ideas and add your comments there to make this feature coming sooner : https://ideas.powerbi.com/forums/265200-power-bi-ideas

Hortonworks Hadoop HDFS, Hive direct data source connection required
DB2 and Hive Direct Query capability. Is this on the roadmap?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

It works great but only the hivesampletable data is present in HDInsight cluster. I want to know how to get other hive table details which are present in hive database. How to push data to HDInsight cluster.