
However the refresh works when I click Edit Query > Refresh ALL, so I am lost as to what this error could mean. Check the ODBC driver logs at the time of issue, If you do not find anything enable trace level logs and check the errors.

I am currently seeing error when refreshing my report from the dashboard. It says 'Unexpected response received from server' you need to check the below things to identify the issue: ( Power BI -> ODBC Driver -> LB -> Impala Daemon ) a. Please ensure the server host and port specified for the connection are correct. Details: 'ODBC: ERROR HY000 Microsoft DriverSupport (1170) Unexpected response received from server. I have been working on this project for couple of months which contains 4 views appended together. ODBC: ERROR HY000 Microsoft DriverSupport (1170) Getting this error when connecting Power BI with Azure Databricks through spark build in connector:. Hope some of these help - let us know if you find a solution. I know not super helpful, but since the query editor only loads a sample of the source data, it may not know a value or field will be error when loading the sample which is why it works in Power Query but not in desktop. Reading the suggestions, they all sounded familiar and eventually I've been able to get things to work.

I don't remember anything specific about each time, but searching the error, I found a page I've read before. HY000 SAP AG authentication error, KBA, HAN-DB-CLI, SAP HANA Clients (JDBC. I've had to deal with this error several times over the years. When using Power BI to connect to HANA database using Data Source, ODBC. Subject: Data refresh failure - OLE DB or ODBC Error
