Forum Discussion

hetadesai56's avatar
hetadesai56
New Member
8 years ago
Solved

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?

APIS and Embedding
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    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 

1 Reply

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    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