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
Fowmy
Super User
Super UserAnonymous
Go to the query editor refresh and check which query generates an error and identify the line. Have you done any Pivot Columns operations?