Forum Discussion
Expression.Error at pivot column step
Hi all I am getting this error message after a pivot column query: Expression.Error: There were too many elements in the enumeration to complete the operation Details: List which a...
Hi v-piga-msft
Thanks for your advice, but I don't think this applies to my case. A few more details - the column that is being pivoted has 3 unique values, none of which match the names of columns that already exist in the table, so I think that rules out your explanation?
If I filter out 2 of those values, so there is just 1 unique name in the pivoted column, the error disappears and the pivot works. If I filter out just 1 of the names, leaving 2 in the column, the error is still present.
Does that provide any clues?
Should anyone else have this problem, it turns out I had some duplicated rows in my dataset. Removing these before the pivot step solved the issue.