Curbal has its own social media server on Mastodon. Check it out here!

Curbal

Learn how to grow your business with your data and Power BI

You are here: Home / Knowledge Base / How to fix the “Too many elements in the enumeration to complete…” pivot error in Power Query
Welcome to our Knowledge Base

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

< All Topics
Print

How to fix the “Too many elements in the enumeration to complete…” pivot error in Power Query

Posted
Updated
ByRuth Pozuelo Martinez

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

Let us know your thoughts...

Table of Contents