Forum Discussion
Helper IIIExpression.Error: There weren't enough elements in the enumeration to complete the operation
This error is thrown when pivoting columns with same name. Please check your column names in your data source. Also refer to a similar thread below:
Regards,
Helper II just want to let you know how this error occurred in mine and how I solved it.
A business process that was used in my Power BI:
I was pulling data from a particular folder and the folder had one file which was updated after a unit time. One day this error showed up.
Solution:
The problem was that there was no file in the folder and this caused this error to occur. the empty folder was causing this to fail.
I hope this helps in any way.
I had this error after moving the folder where i kept files to a different location and forget to change new location in one of the table.
- Mrab
can you share a screenshot of the column names for the 2 files or more than 2 files you are using?