Forum Discussion
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:
- Upgrade RAM of machine
- Decrease number of rows and/or number of columns in this visual
- 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
- 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
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:
- Upgrade RAM of machine
- Decrease number of rows and/or number of columns in this visual
- 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
- 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