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,
Advocate IIWhen I faced this error, the issue turned out to be that my query was using a 'Helper Query' involving a 'Sample File' and the sample file no longer existed in the original location.
The query was using 'Source = SharePoint.Files' and I had relocated the SharePoint folder. While had updated the filepath in my query itself, I'd neglected to realise that Power BI Desktop had created a 'Helper Query' and that I needed to update the source in that too.
I have followed your steps below and resolved my issue:
1) I had relocated the SharePoint folder and
2) updated the filepath in my query
3) but neglected to realise that Power BI Desktop had created a 'Helper Query' and that I needed to update the source in that too
Thank you Simon
Hi Simon,
Would you delete the query if you realized that it was pointing to folder and details that are no longer used?
