Odbc connection error from power bi 1170

[Gchandrukris]

Hi
I am using hdinsight to connect my hive db. Intermittently I am getting this 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."
What is wrong..can you help me on this

[amitchandak]

Refer: https://docs.microsoft.com/en-us/azure/hdinsight/hadoop/apache-hadoop-connect-excel-hive-odbc-driver...

Make sure you are using the supported version from https://www.cloudera.com/downloads/connectors/hive/odbc/2-6-4.html

[Greg_Deckler]

Generally this means that you have a wrong server name, something is blocking your port or you have old credentials stored in Power BI. Here are a few links to help:

https://stackoverflow.com/questions/55586935/odbc-error-hy000-microsoftdriversupport-1170

https://community.powerbi.com/t5/Power-Query/ODBC-Connection-Error-Driver-Error/td-p/163517

Otherwise, will need more information to go on. Also, you could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".