How to Integrate PowerBI with Qubole Data Service ?

[hetadesai56]

I want to execute the query on Qubole cluster and visualize data on PowerBI. I am using Qubole service on Microsoft Azure. How can I Integrate both PowerBI and Qubole Data Service?

[v-qiuyu-msft · Accepted solution]

Hi @hetadesai56,

Based on my research, we an download and install Qubole ODBC Driver, create a ODBC data source. In Power BI desktop, get data from the ODBC data source. 

If you want to publish the report to Power BI service then perform data refresh, as the ODBC data source requires gateway and gateway only has 64 bit currently, I would suggest you install 64 bit driver and use 64 bit Power BI desktop. 

Best Regards,
Qiuyun Yu