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.
Hello Folk's, Hope all doing good.
I have a question go through it and give me a answer!
I went through the article below:
https://community.hortonworks.com/articles/61185/visualizing-hive-data-using-microsoft-power-bi.html | Hadoop Big data
It would be nice if you can let us know whether
1. Power BI can connect with Hive in Direct Query mode.
2. Whether it is possible to schedule data refresh for Power BI reports (in import mode) using on-premises gateway.
Please refer any links to articles describing Hive and Power BI connectivity.
Thanks & Regards,
Nicolewells
Solved! Go to Solution.
Hi @nicolewells,
>>1. Power BI can connect with Hive in Direct Query mode.
Connection to Hive in Direct Query mode is unsupported to date. Please review the following ideas and vote them.
Hortonworks Hadoop HDFS, Hive direct data source connection required
DB2 and Hive Direct Query capability. Is this on the roadmap?
>>2. Whether it is possible to schedule data refresh for Power BI reports (in import mode) using on-premises gateway.
You can create ODBC data source for cloudera hive, then connect to the ODBC data source in Power BI Desktop, then publish it to service, add ODBC data source under the gateway following the guide in this similar thread, then checkif it works.
Best Regards,
Angelia
Hi @nicolewells,
>>1. Power BI can connect with Hive in Direct Query mode.
Connection to Hive in Direct Query mode is unsupported to date. Please review the following ideas and vote them.
Hortonworks Hadoop HDFS, Hive direct data source connection required
DB2 and Hive Direct Query capability. Is this on the roadmap?
>>2. Whether it is possible to schedule data refresh for Power BI reports (in import mode) using on-premises gateway.
You can create ODBC data source for cloudera hive, then connect to the ODBC data source in Power BI Desktop, then publish it to service, add ODBC data source under the gateway following the guide in this similar thread, then checkif it works.
Best Regards,
Angelia
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |