Power BI PRO y Premium Data Source

[maria899]

Hola, me gustaría preguntar si Power BI PRO y Premium tienen conectores para Impala o Hive

[v-frfei-msft · Accepted solution]

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?

[Seth_C_Bauer]

@maria899 

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

[maria899]

Thanks for your reply.

I would like to know if its possible connect to Hive