Forum Discussion
Anonymous
2 years agoNot applicable
API loads into Power Query, but not into report
Hi all, wondering if you can help me with this issue. I'm pulling data into my report via an API that we pay for access to (SEMrush Standard API). My API pull request appears to be working f...
audreygerred
2 years agoSuper User
Hello! Based on what I have read, this error typically means you attempted to modify a collection (list or array) while iterating over it. Make sure you are not modifying the data structure while iterating over it (if you do need to modify you can create a separate collection to house the modified data), concurrency could cause issues, make sure concurrent modifications are prevented, some operations might not be supported while iterating over it, and nested iterations can cause issues so make sure you aren't modifying the outer collection while iterating the inner collection. Review the code and look for areas that you modifying while iterating, then change to avoid that pattern.