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?

Reader Interactions

Comments

  1. Hi Ruth,

    Thanks so much this helped me out of a tight spot with a Power query error! Great solution!

Leave a Reply

Your email address will not be published. Required fields are marked *

Table of Contents