Connect Power BI to HBase Big Data

[jaypatel]

Hi all,

I need to connect Power BI to HBase for data visualisation in Power BI. I have done some research and I come to know that there is CData HBase ODBC Driver and Simba HBase ODBC Driver with SQL Connector. 

I have referred this link. 

So is there any other solution for connection of Power BI and HBase?

Regards,

Jay.

[amitchandak]

These seem fine. ODBC in another option

https://docs.microsoft.com/en-us/power-bi/desktop-connect-using-generic-interfaces

HD insight

https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-using-spark-query-hbase

[jaypatel]

Once I connected Power BI with Hive using ODBC connector, and that ODBC driver was free. Can I use the same ODBC driver for HBase connection to Power BI ??  

[jaypatel]

@v-lionel-msft 

Hey,

I download Driver and want to configure it, but won't able to configure. I have referred this link, I followed. But I don't the default port of HBase. I tried below port for connection; I am using Hortonworks Sandbox in Virtual box.

Server: 127.0.0.1

Port: 8020,8050,16000,16010,16020,16030

Although I am not sure where I am doing what wrong. 

Please help me for the same.

Thanks,

Jay

[jaypatel]

@v-lionel-msft 

I have also tried with SIMBA ODBC driver, nut still unable to fetch data.

[jaypatel]

@v-lionel-msft 

Hi Sir,

Thank you for repose. I tried to connect using this driver too. But still, I am unable to connect my HBase to Power BI. 

As I mentioned before, I am using Hortonworks Sandbox in my Local system.

Below are my configurations;

I tried with many ports. (i.e 8020,8050,8080,10500,16000,16010,16020,16030)

Regards,

Jay

[jaypatel]

@v-lionel-msft 

Thank you Sir for the reply, I have already referred these links, but I am in the search of alternative of the aforementioned driver which is free fo all time. 

Regards,

Jay