Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Impala ODBC : Memory limit exceeded error

 Hello Everyone,

 

I have a report which is connected to Impala using an ODBC connection. The data set is also huge.

While refreshing the preview on Power Query I get the below errorImpala error.JPG

 

 

Could someone kindly guide me how to resolve this please..

 

Thank you in advance.

 

Swathi

1 REPLY 1
Anonymous
Not applicable

Hi @Anonymous ,

The “Memory limit exceeded” error in Impala usually indicates that the SQL query you’re running is consuming a large amount of memory to process the data. This could be due to the size of the dataset being processed or the complexity of the query itself.

You can increase the memory limit of the Impala daemon. If you’re not the administrator, you might want to check with them to see if they can allocate more memory to your user.
hadoop - Memory limit exceeded - Apache Impala
Solved: Impala - Memory limit exceeded - Cloudera Community - 80407
Solved: Backend 6:Memory Limit Exceeded" in impala 2

If possible, try to optimize your query. This could involve reducing the amount of data being processed, using filters to limit the data, or breaking the query into smaller parts
hadoop - Cloudera Apache impala query: Memory limit exceeded

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors