Forum Discussion

Icon for Helper III rank

Helper III

10 years ago

Solved

Expression.Error: There weren't enough elements in the enumeration to complete the operation

What does this error mean? I am collecting data from using a web connector. Any help much appreciated.

v-sihou-msft
10 years ago
sebbyp

This error is thrown when pivoting columns with same name. Please check your column names in your data source. Also refer to a similar thread below:

https://social.technet.microsoft.com/Forums/en-US/7923e025-a0c4-407b-bd0f-65959e5038bb/what-does-this-mean-expressionerror-there-were-too-many-elements-in-the-enumeration-to-complete?forum=powerquery

Regards,

Icon for Microsoft Employee rank

Microsoft Employee

10 years ago

This error is thrown when pivoting columns with same name. Please check your column names in your data source. Also refer to a similar thread below:

https://social.technet.microsoft.com/Forums/en-US/7923e025-a0c4-407b-bd0f-65959e5038bb/what-does-this-mean-expressionerror-there-were-too-many-elements-in-the-enumeration-to-complete?forum=powerquery

Regards,

Regular Visitor

6 years ago

I couldn't find a duplicate column.

From Power Query Editor
= #"Reordered Columns"{0}[Planned Date]

Expression.Error: There weren't enough elements in the enumeration to complete the operation.
Details:
[Table]

Related content