CODEWITHSUNDEEP
powerbiazure-databricks
meenu sheokand
meenu sheokand

Reputation: 11

ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1170)

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 server. Please ensure the server host and port specified for the connection are correct."

I have checked many times host and port of the databrick cluster , and also tried after restarting of cluster .

Guide for the connection:- https://docs.azuredatabricks.net/user-guide/bi/power-bi.html

Upvotes: 1

Views: 25978

Answers (2)

Polto
Polto

Reputation: 95

The user was not able to import SQL data Power BI and getting this error, while testing connection in ODBC was successful. It turned out that he has old credentials stored in PowerBI, and that caused identification issues. Purging cached data sources (Power BI: Home >Edit Queries > Data source settings" resolved the issue.

Upvotes: 0

user8143344
user8143344

Reputation:

Got the same problem today. I followed these instructions and it worked.

Upvotes: 1

Related Questions