I have a Power BI with ODBC Connection to Impala. I have a situation that Power BI will refresh the Dashboard with scheduled everyday. But somehow, when the refresh start, it got an error:
ERROR [HY000] [Cloudera][ImpalaODBC] (120) Error while retrieving data from in Impala:  :
I'm so confused, the error log only shown like that in my Power BI log refresh history. When I check on my Impala Log History. It shown such below:
User: xDatabase: xQuery Type: QueryPool: root.XDuration: 10.36sAdmission Result: Cancelled (queued)Query State: EXCEPTION
The rest of other query were Error, with Query Status : Session closed because it has no active connections.
Can you please confirm if you are using any timeout settings from PowerBI end?