insufficient memory

[CLCastroEn]

Hello everyone!! 1

I have a pretty big base with over a million rows. now I wanted to add a new column to it, starting with dax. I did it and it throws me the following message: there's not enough memory to complete this operation. please try again later when there may be more memory available.

The dax column is basically composed of 8 IF containing 4 measures within... is it better if I do the IF without the measures?

[v-janeyg-msft]

Hi,  @CLCastroEn 

It’s my pleasure to answer for you.

According to your description,I think it is dax which is causing the issue. Bad written DAX or poor data model can have great impact on the performance and can slow down everything.

Could you mind share your formula? Maybe I can help you see if I can optimize it. You can also use Performance Analyzer to analyze which measure or column takes a long time to query.

If it doesn’t solve your problem, 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.

[amitchandak]

@CLCastroEn , refer if these two can help

https://blog.crossjoin.co.uk/2020/01/20/visual-has-exceeded-the-available-resources-error-power-bi/

https://windowsreport.com/memory-error-allocation-failure/