Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to Solution.
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
When this error happens at 'pivot column --It could be duplicated value in some columns, make sure every data in one row is unique.
@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?
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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
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!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
29 | |
12 | |
12 | |
11 | |
8 |
User | Count |
---|---|
53 | |
27 | |
15 | |
14 | |
13 |