Forum Discussion
Dataflow Updating Error "Too many elements in the enumeration"
lbendlin I actually figured this out yesterday afternoon.
The 'Enumeraton error' was caused by the pivot. We had a duplicate entry that was folding more than one entry into a cell causing an error. We didn't expect a duplicate entry and obviously the pivot worked but just errored out that row. We couldn't see the error as it was only one in 16k rows and the columns filters didn't see it, I presume because it occured too far through the dataset to be picked up.
The merge worked fine because, again, it was just a row with an error, but when we updated the dataflow outside of PowerQuery the JSON fell over and told us we had an error but, as with most Microsft error messages, it wasn't helpful in finding it.
The upshot of this is that I now understand the term 'Too many elements in the enumeration'.
lbendlin I actually figured this out yesterday afternoon.
The 'Enumeraton error' was caused by the pivot. We had a duplicate entry that was folding more than one entry into a cell causing an error. We didn't expect a duplicate entry and obviously the pivot worked but just errored out that row. We couldn't see the error as it was only one in 16k rows and the columns filters didn't see it, I presume because it occured too far through the dataset to be picked up.
The merge worked fine because, again, it was just a row with an error, but when we updated the dataflow outside of PowerQuery the JSON fell over and told us we had an error but, as with most Microsft error messages, it wasn't helpful in finding it.
The upshot of this is that I now understand the term 'Too many elements in the enumeration'.