I am having the same issue. I have a function that picks the latest date and time out of 5 Mn rows. And then uses that against other rows to calculate the relative age which then becomes the basis of the period for the chosen metric. It works well on my PBIX file as my desktop has 32 GB RAM. Our On Premise Datagateway runs on a VM with 4 GB RAM. Is there a possibility that if I increase the RAM on the VM, it would work fine?
I'm having the same issue with a visual that uses 2 DAX fields to calculate cumulative profit $ between 2 dates, this year and last year. The visual is just a line graph. It was fine until 4-5 days ago.
This is annoying since the visual is exactly what the UI and DAX should be for..
There are several topics where this issue is mentioned, but it looks like this one has the extensive discussion. I'd like to know what resources we're talking about. Is it CPU or memory? Is the limit on the server hosting SSAS, on the Gateway server, on the pc/laptop running Power BI Desktop/Service or is the limit on Microsofts side so that we cannot upgrade the resources that are being exceeded? If anyone knows anything about this, I would really appreciate it if you'd share it here.
Also having this issue. Does not make sense. Need to understand limits better as it is turning a supposedly enterprise-level tool into a bear for certain critical tasks within my relatively-small dataset.