How to fix the “Too many elements in the enumeration to complete…” pivot error in Power Query
Have you ever got the error: Expression.Error: There were too many elements in the enumeration to complete the operation. when pivoting tables in Power Query? In today’s video I will show you why you get the error and two ways to fix it.
Table of contents:
00:00 Intro & Issue description
00:35 Split columns into rows by a delimiter
01:00 Showing the error
01:30 Explaining why and when the error occur
02:20 Solution 1
02:30 Add an index column to a grouped table
04:00 Solution 2 (faster)
Watch the tutorial:

Was this helpful?
Hi Ruth,
Thanks so much this helped me out of a tight spot with a Power query error! Great solution!