New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

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:

How to fix the "Too many elements in the enumeration to complete..." pivot error in Power Query
Was this helpful?
Previous Keep most recent record on a table with Power Query | Improved solution – Part 2
Next Add index to nested tables in Power Query

Reader Interactions

Let us know your thoughts...

Table of Contents