Forum Discussion

yoshihirok's avatar
yoshihirok
Icon for Post Prodigy rankPost Prodigy
8 years ago
Solved

Can I connect Azure Databricks from Power BI Desktop by DirectQuery?

I want to know, Can I connect Azure Databricks from Power BI Desktop by DirectQuery? Currently, the data sources for DirectQuery support Apache Spark on Azure HDInsight and Spark. https://docs.mi...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    Hi yoshihirok,

     

    Power BI Desktop can be connected directly to an Azure Databricks cluster using the built-in Spark connector (Currently in preview). The connector enables the use of DirectQuery to offload processing to Databricks. For more details, please check the online document.

     

    Regards,

    Frank

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

I followed the steps but no luck in connecting databricks from power BI.

getting below error.


Details: "ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct."

 

any help will be much appreciated.

Thanks

Jith