API loads into Power Query, but not into report

[TMason]

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 fine because I can successfully pull the data into Power Query & when I've queried this issue with SemRush, they say that the call appears to be working fine from their end.

However, when I try to load it into my report I get the following error: Collection was modified; enumeration operation may not execute.

From my research it sounds like it's a credentials related issue on the PowerBi side, however clearing the credentials hasn't fixed the problem. 

Does anyone have any ideas on how to fix?

Thanks all 🙂

[audreygerred]

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.