Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 error. Any help to identify and resolved this error.

 

Regards,

Tamilselvi K

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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

    • rathom01's avatar
      rathom01
      New Member
      2 years ago

      It works for me. We are referring to Sharepoint list and an excel template. Unfortunately, my colleague rename the file. Once I change the name in Power Query, data loaded. Thanks!

      • B_K_Mutie's avatar
        B_K_Mutie
        Regular Visitor
        2 years ago
        Thank you very much. This worked the magic for me!
  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Anonymous 

    Go to the query editor refresh and check which query generates an error and identify the line. Have you done any Pivot Columns operations?


  • LoopytheRabbit's avatar
    LoopytheRabbit
    New Member
    4 years ago

    When this error happens at 'pivot column --It could be duplicated value in some columns, make sure every data in one row is unique.