EXPRESSION ERROR LIST

[DeborahOliveira]

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!

[BA_Pete]

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