Forum Discussion
Mem Limit Issue (Impala)
Hi Anonymous , Thank you for reaching out to the Microsoft Community Forum.
Ask your Impala administrator to create a new view that wraps your existing query and routes it through a resource pool with a higher memory limit. That pool should have min-query-mem-limit set to at least 3.28 GB, based on the error you're seeing.
Once the view is in place, you can connect to it in Power BI just like any other table or view, no changes needed on your side. This works because Impala handles memory allocation server-side, and Power BI doesn’t support SET commands or hints like /*+ SET_VAR */ for MEM_LIMIT.
If this helped solve the issue, please consider marking it “Accept as Solution” so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.
Sadly, I don't have access to configure it on my ODBC Connection. I'm looking for a way to do it within Power BI itself.
Community SupportHi Anonymous , Thank you for reaching out to the Microsoft Community Forum.
Ask your Impala administrator to create a new view that wraps your existing query and routes it through a resource pool with a higher memory limit. That pool should have min-query-mem-limit set to at least 3.28 GB, based on the error you're seeing.
Once the view is in place, you can connect to it in Power BI just like any other table or view, no changes needed on your side. This works because Impala handles memory allocation server-side, and Power BI doesn’t support SET commands or hints like /*+ SET_VAR */ for MEM_LIMIT.
If this helped solve the issue, please consider marking it “Accept as Solution” so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.