Forum Discussion

adelmonte's avatar
adelmonte
Icon for Resolver I rankResolver I
4 years ago
Solved

Pivot Column Error - There were too many elements in the enumeration to complete the operation.

Hi all, I am trying to pivot a column in power query and I get an error: Expression.Error: There were too many elements in the enumeration to complete the operation. Details: [List] Any id...
Need Help
  • adelmonte's avatar
    adelmonte
    4 years ago

    I added Source name column and used uniqueness of that column to pivot and it worked fabulously 🙂

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi There,

 

Its not working for me. still getting same error.

 

 

Anth79's avatar
Anth79
Icon for Advocate I rankAdvocate I
2 years ago

I had the same issue. I added an Index column before my pivot, as suggested by parry2k, and my pivot worked after that. 

Related content