cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
hetadesai56 Visitor
Visitor

How to Integrate PowerBI with Qubole Data Service ?

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: How to Integrate PowerBI with Qubole Data Service ?

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 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Moderator v-qiuyu-msft
Moderator

Re: How to Integrate PowerBI with Qubole Data Service ?

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 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.