Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |