Forum Discussion
sebbyp
Helper III
Helper IIIExpression.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.
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:
Regards,
v-sihou-msft
Microsoft Employee
Microsoft Employee
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:
Regards,
kymramosrpo
Advocate V
Advocate VTo add to this, here's a video tutorial by ruthpozuelo that I was very grateful to have found:
How to fix the "Too many elements in the enumeration to complete..." pivot error in Power Query
Curbal, Mar 16, 2020