Forum Discussion
Conditional column taking more ram than expected
Hey Guys!!! We have a conditional column which is being used as a filter in many reports, we observed that conditional column is taking up huge RAM around 50 GB(Yes you read it right its 50 gigs ...
Not sure what you mean here. Power Query uses as much memory as it needs for the data. If you have 24GB of data after compression, then you have 24GB of data and no amount of formula changes will fix that. When the service says you are out of memory, that is what it means. If it is 24GB, that is millions and millions of rows. By default it is chunking it into 1M segments, but should be 8M record segments if you have "enable large dataset" in the model settings on the service. But once it is in the model, it is still in a temp place. Once all tables are refreshed successfully, then Power BI will swap out the databases. M code has nothing to do with this final step.
