Forum Discussion
Power BI PRO y Premium Data Source
Hola, me gustaría preguntar si Power BI PRO y Premium tienen conectores para Impala o Hive
Hi maria899 ,
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.
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?
3 Replies
- AnonymousNot applicable
Connectors are the same for both Pro and Premium. You can connect to impala -> https://docs.microsoft.com/en-us/power-bi/desktop-connect-impala
Google translate:
Los conectores son los mismos para Pro y Premium. Puede conectarse a impala -> https://docs.microsoft.com/en-us/power-bi/desktop-connect-impala
- maria899New Member
Thanks for your reply.
I would like to know if its possible connect to Hive
- v-frfei-msft
Community Support
Hi maria899 ,
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.
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?