Tabular Source : Memory Allocation Failure

Hi Anonymous ,

When we receive a Memory Allocation issue either at Power BI Desktop either at Analysis Services Tabular then it is not a limit of them it is a limit of machine where they are running (your PC, server etc.).

When Power BI connected to a source Live or via DirectQuery then each visual sends a request to a source and a result is returned to a visual, but it can't cause memory issue here. In your case your huge visual sends a DAX request to Tabular which consume too much RAM (memory) at a machine where Tabular is running. 

In order to solve this you have 4 options:

1. Upgrade RAM of machine
2. Decrease number of rows and/or number of columns in this visual
3. Optimize and reduce data in Tabular model. The goal is to reduce amount of data stored in RAM. It is separate science and huge topic, actually
4. Check the query which was sent by a visual to Tabular and try to optimize a model to make this query lighter. Use DAX Studio or SQL Server Profiler to connect to Tabular and trace it

Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!

You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups