Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Issue with databrick cluster and Power BI connection using spark cluster

getting this error when connecting Power BI with Azure Databricks through spark build in connector: Details: "ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1170) Unexpected response received from ...
Need Help
v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi, Anonymous 

 

Maybe old credentials are stored in Power BI, which may cause identification issues. You may purge cached data sources.(Power BI: Home >Edit Queries > Data source settings). The issue may be related to your odbc driver, please check and confirm  you installed a correct version. I wonder if you are using Azure spark or on-premise spark datasource. If you mean Azure spark, you may refer to the following link.

https://docs.microsoft.com/en-us/azure/hdinsight/spark/apache-spark-use-bi-tools

 

Best Regards

Allan

 

If this post helps, then please consider Accepting it as the solution.

glocea's avatar
glocea
New Member
6 years ago

Hello,

 

Since yesterday, I cannot connect to my spark cluster datasource.

I erased my authentication settings, generate a new token on databricks and log again to my data source.

 

I keep getting this error

ODBC: ERROR [HY000] [Microsoft][Hardy] (100) The host and port specified for the connection do not seem to belong to a Spark server. Please check your configuration.

 

Do you have any ideaabout it ? My Power BI Desktop has been updated automaticaly to this version Version : 2.78.5740.721 64-bit 

  • deepu299's avatar
    deepu299
    Icon for Advocate V rankAdvocate V
    6 years ago

    I had same issue, it seems to be enterprise firewalls. I didn't troubleshoot to find it out, rather used an Azure VM to try and it worked fine. So note that I am just making an assumption here.