Getting error when refreshing data from Impala

[halamsjah]

I have been getting an error trying to refresh data from Impala on daily basis with underlying error message of ERROR [08S01] [Microsoft][ImpalaODBC] (120) Error while retrieving data from in Impala: [08S01] : ImpalaThriftAPICallFailed or [Microsoft][ImpalaODBC] (450) Error when calling the Impala Thrift API GetTables: ETIMEDOUT.

Is there anyone received the same error and how do you fix it?

Thanks

Underlying error code: -2147467259
Underlying error message: ODBC: ERROR [08S01] [Microsoft][ImpalaODBC] (450) Error when calling the Impala Thrift API GetTables: ETIMEDOUT
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind: Impala
Microsoft.Data.Mashup.ValueError.DataSourcePath: srphdw001.srp.gov:21050
Microsoft.Data.Mashup.ValueError.OdbcErrors: #table({"SQLState", "NativeError", "Message"}, {})
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error
Cluster URI: WABI-WEST-US-C-PRIMARY-redirect.analysis.windows.net
Activity ID: 849c0187-d77d-4c38-9ebd-51539cc1d555
Request ID: 3f9e8002-53e9-d783-e8d8-377ed334bb83
Time: 2022-05-24 16:57:45Z

[v-chenwuz-msft]

Hi @halamsjah ,

The message shows ETIMEDOUT. Possible cause of connection information error.

Please try to use Power BI desktop to connect to the database via Impala. See if it runs successfully.

If so, please re-upload,

if not, please check if the database server is available. See if the port number of the server is correct.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.