Forum Discussion
itsmeanuj
4 years agoHelper IV
DAX to M Code
Hi Guys, My PBI Workbook has become very heavy lately and refreshing takes 20GB of memory. my system is 32 GB and I am afraid that it will surpass that memory and would need more space. there are...
Anonymous
4 years agoNot applicable
You will need to end up doing a bunch of transformations in Power Query nevertheless, even there are some things that you could only do with DAX. In my experience, I don't think it will make a difference if you switch them to M, it might even take more time. It seems the issue relies on the size of the dataset, the steps applied on Power Query or even the connectors to your data source.
itsmeanuj
4 years agoHelper IV
ok! you mean to say that memory usage issue would not be solved even if we move some calculations to query editor from DAX?
- Anonymous4 years agoNot applicable
How many rows do you have in your dataset?
- itsmeanuj4 years agoHelper IV
as of now 150K. but it keeps increasing with each passing day.