Forum Discussion

Regular Visitor

5 years ago

Solved

Out of memory while reading tuples

Hi! I have big report (200mb) and can't remove anything from a model (If I need to calculate something i used measures). From today i get the memory error (ODBC: ERROR [HY001] Out of memory whil...

Need Help

v-janeyg-msft
5 years ago
Hi, ilyabokof

For big data models, optimization is very important. Secondly, it is also important to choose the appropriate connection mode and allocate the refresh and usage time between reports reasonably. If you use premium capacity, you can configure the workload according to different needs, increase the query memory limit, or purchase a larger capacity license, which can also be considered.

Best Regards

Janey Guo

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

v-janeyg-msft

Community Support

5 years ago

Hi, ilyabokof

Make sure that when you refresh the report, there are not many other refresh processes in the tenant, otherwise it may cause insufficient memory allocation and refresh failure. If there is a premium license in the organization, you can put the report in the premium capacity, and the performance of running and refreshing the report will be improved because the query memory increases.

Reference: Configure and manage capacities in Power BI Premium - Power BI | Microsoft Docs

How to configure workloads in Power BI Premium - Power BI | Microsoft Docs

Or you can check the similar case:

Out of memory while reading tuples; memory allocat... - Microsoft Power BI Community

Solved: Memory error: Memory Allocation failure. - Microsoft Power BI Community

You may still need to control the size of the model, delete unnecessary columns, and use measure instead of column as much as possible.

If you still have problems, please feel free to ask me.

Best Regards

Janey Guo

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