Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

Expression Error : There weren't enough elements in the enumeration to complete the operation

Hi,

 

During Data refresh its failing stating "There weren't enough elements in the enumeration to complete the operation" but i'm not sure in which table i'm getting this error and how to fix this error. Any help to identify and resolved this error.

 

Regards,

Tamilselvi K

1 ACCEPTED SOLUTION
watkinnc
Super User
Super User

That usually means that you are trying to perform operations on an empty table or list. To fix it, go to the query editor and see  which table is not loading; you should see an error. You can review each step to see which is causing the error. 
--Nate


I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

View solution in original post

5 REPLIES 5
LoopytheRabbit
New Member

When this error happens at 'pivot column --It could be duplicated value in some columns, make sure every data in one row is unique.  

Fowmy
Super User
Super User

@Anonymous 

Go to the query editor refresh and check which query generates an error and identify the line. Have you done any Pivot Columns operations?


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

watkinnc
Super User
Super User

That usually means that you are trying to perform operations on an empty table or list. To fix it, go to the query editor and see  which table is not loading; you should see an error. You can review each step to see which is causing the error. 
--Nate


I’m usually answering from my phone, which means the results are visualized only in my mind. You’ll need to use my answer to know that it works—but it will work!!

It works for me. We are referring to Sharepoint list and an excel template. Unfortunately, my colleague rename the file. Once I change the name in Power Query, data loaded. Thanks!

Thank you very much. This worked the magic for me!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.