Forum Discussion

patri0t82's avatar
patri0t82
Post Patron
5 years ago
Solved

Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.

Hello, I have a solution in place for my company that's been working fine for over a month, but now I'm receiving this error. I have no idea what could be causing the problem, as there's not many que...
Need Help
  • timg's avatar
    timg
    5 years ago

    Hi,

    If I understand correctly you are currently creating the column that is causing the issue with dax. You could try and add this column in power query instead. Calculated (dax) columns are not compressed as well as computed (power query) columns. So this could potentially save you the needed resources. The duration.totext() function in power query can be used to calculate the time difference between two timestamps so this may be a good place to start.

    Regards,

    Tim

timg's avatar
timg
Solution Sage
5 years ago

Hi,

If I understand correctly you are currently creating the column that is causing the issue with dax. You could try and add this column in power query instead. Calculated (dax) columns are not compressed as well as computed (power query) columns. So this could potentially save you the needed resources. The duration.totext() function in power query can be used to calculate the time difference between two timestamps so this may be a good place to start.

Regards,

Tim

patri0t82's avatar
patri0t82
Post Patron
5 years ago

Thanks for this suggestion, I will reach out to someone in the general forum with regards to this.