Forum Discussion

DeborahOliveira's avatar
DeborahOliveira
Frequent Visitor
3 years ago

EXPRESSION ERROR LIST

Hi could anyone tell me what does this error mean and how to fix?

 

Expression.Error: There were too many elements in the enumeration to continue the operation.

Details: [List]

 

i was trying to create a piviot table, some informations are appearing and some are saying Error and when i click on it says the following. 

 

if anyone could help me out, i'll be very greatfull!

Need Help

1 Reply

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    Hi DeborahOliveira ,

     

    This usually happens when there's no unique row ID for Power Query to use to put all the values back in the correct place after the pivot operation.

    Try just adding an Index column before the pivot operation and don't include it in the columns to pivot.

     

    Pete