Forum Discussion
HxH
Advocate II
Advocate IINot enough memory to complete this operation - column creation
Hi guys,
this is a follow up to another topic when a user kindly provided a measure to calculate time not working in a table
This is the measure:
Time not working =
var currentUser= 'TABLE'[UserID]
var currentdate = 'TABLE'[Date]
var currentlog = 'TABLE'[logs]
var currenttime = 'TABLE'[Datetime]
var nexttime = IF(currentlog=0,CALCULATE(MIN('TABLE'[Datetime]),ALL('TABLE'),'TABLE'[Datetime]>currenttime,'TABLE'[UserID]=currentUser,'TABLE'[Date]=currentdate,'TABLE'[logs]=1))
var timenotworking = DATEDIFF(currenttime,nexttime,MINUTE)
return
timenotworking
The table has 107k rows and 9 columns. It keeps telling me that there is not enough memory to perform the operation. The point is: i can create as much columns as I want in the table, this is the only one that won't work for memory problems. Could PBI be referring to another kind of problem with the wrong message error? Do you know what's happening? I tried looking at previous threads but in all the other situations the problem seems justified (there's people with millions of rows, other trying to load 57 tables and so on), my case is weird because I can create as much columns as I want beside this one so I can't figure it out.
I've already done the standard stuff like disabling auto/date time and allow data preview to dowload in background
Thanks
The table has 107k rows and 9 columns. It keeps telling me that there is not enough memory to perform the operation. The point is: i can create as much columns as I want in the table, this is the only one that won't work for memory problems. Could PBI be referring to another kind of problem with the wrong message error? Do you know what's happening? I tried looking at previous threads but in all the other situations the problem seems justified (there's people with millions of rows, other trying to load 57 tables and so on), my case is weird because I can create as much columns as I want beside this one so I can't figure it out.
I've already done the standard stuff like disabling auto/date time and allow data preview to dowload in background
Thanks
5 Replies
HxHMemory in use goes up to 96-97% and then it gives me the error message. Looks like I will need to do some work in power query to improve the model or change the measure. Thanks
