Forum Discussion
Expression Error : There weren't enough elements in the enumeration to complete the operation
Hi, During Data refresh its failing stating "There weren't enough elements in the enumeration to complete the operation" but i'm not sure in which table i'm getting this error and how to fix this...
That usually means that you are trying to perform operations on an empty table or list. To fix it, go to the query editor and see which table is not loading; you should see an error. You can review each step to see which is causing the error.
--Nate
When this error happens at 'pivot column --It could be duplicated value in some columns, make sure every data in one row is unique.