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: x
Database: x
Query Type: Query
Pool: root.X
Duration: 10.36s
Admission Result: Cancelled (queued)
Query State: EXCEPTION
The rest of other query were Error, with Query Status : Session closed because it has no active connections.