Ready to curb your Power BI skills? Find out more here!
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

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!

Let us know your thoughts...

Table of Contents