Forum Discussion
Expression.Error: There weren't enough elements in the enumeration to complete the operation
ImkeF No, that was the right one. That's the rub...it does work "a lot" of the time, but randomly decides to throw that enumeration error. Is it possible the data source could cause an issue? I just ask because I know that site is sometimes very slow in loading, so wondering if something on the server side could cause the issue?
If you're saying nothing is wrong with it, I believe that. I have been telling Seaweed81 that I felt the model was fine, it was an issue on the data side, though I didn't know how to verify this assumption...
I think I have the same issue, because I load the data from a database, and then do some editing steps in Query editor where I change column names etc.
And when the data is slow to load from the database it seems like it tries to jump over to renaming the columns (where there are none to rename because the data has not loaded), thus causing the expression error. Or that is at least my theory on it.