Forum Discussion
Memory fail
I am not able to save the calculation in the model because the memory is not enough. I have 128 GB memory still it is not able to perform the calculation for column which is derived through a measure.
Do I have to upgrade the memory ? Or try to rewrite the DAX.
I have used Distinct in the Calculate function and I can use Values in place of Distinct. Does it make any difference ?
Or should I restrict the number of rows.
Thanks
2 Replies
BishwaR , Try rewrite distinct as
Countx(values(Table[Column]), calculate(Max(Table[Column])))
or
countx(summarize(Table[Column]), [Column])
Also, Increase data cache management to 16GB
Hi BishwaR ,
First, you can find out what consumes memory by looking inside the two links below.
Are Your Power BI Performance Issues Due To High Memory Consumption?
Understanding memory used by Power BI
Then, refer to the following blog to reduce your model size and optimize the DAX:Optimize/Reduce model:
Data reduction techniques for Import modeling
DirectQuery model guidance in Power BI Desktop
Optimize DAX:
In addition, the following one is the thread with similar problem to yours, check out the solution. Hope he can help you.
Best Regards
