question Re: Error when updating Power BI connected to Impala with Cloudera ODBC Driver for Impala in Support Questions

Error when updating Power BI connected to Impala with Cloudera ODBC Driver for Impala

AnaIsabel — Thu, 05 Jun 2025 07:23:10 GMT

Hello community,

I have a PowerBi application with some dashboards. The dashboards are updated according to the configuration at least 2 times a day. The dashboards connected to Impala sometimes do not update and I get this error (see below). It does not happen all the time but many times. I have to update it manually every time I get the error. I use cloudera ODBC driver (64 bit) and basic gateway (PowerBi Cloud): on-premise data gateway.

Can you help me to solve the update problems?

Thank you,

Translated with DeepL.com (free version)

Error message:

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}}, {"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"10478"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Impala"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"md-iplb-rbap.emea.bosch.com:21050"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: qmm_process_uss5_fermasilb_batch.URI de clústerWABI-NORTH-EUROPE-L-PRIMARY-redirect.analysis.windows.net

Re: Error when updating Power BI connected to Impala with Cloudera ODBC Driver for Impala

DianaTorres — Thu, 05 Jun 2025 19:55:18 GMT

@AnaIsabel Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our Impala experts @jAnshula @Boris G @Saurabhatiyal who may be able to assist you further.

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.

Re: Error when updating Power BI connected to Impala with Cloudera ODBC Driver for Impala

Boris G — Thu, 05 Jun 2025 20:40:23 GMT

Hello-

The error you have provided:

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

- is quite obscure. The following could cause it:

a. outdated ODBC Driver

b. intermittent network issue

c. misconfigured or malfunctioning Load Balancer.

d. invalid certificate(s) on one or few Impala coordinators (behind the Load Balancer).

- each of the above or some combination of those.

In order for us to help you with troubleshooting, please open a case with Cloudera Support.

Thank you.