Power Automate Foreach 501 items limit

Question

I am trying to loop through parsed json elements to write data to a variable, that will be sent as a CSV. Unfortunately, the loops stop looping at 501 items :

---

Others flows are doing the same thing sucessfully, having less than 500 item !

From what i seen online, the loop have a 5k elements limits. Why would it stop at 501 items precisely each time ?

Thank you !

Answer 1

Thanks to the suggestion of @Sam Nseir Problem was not on the loop itself but on the dataset request. Since i used a DAX request from a table visual in Power BI desktop, i did not noticed that it included a TOPN 501 limitation.

Corrected request allow to take 5000 elements look like this :

    VAR __DS0PrimaryWindowed = 
    TOPN(
        5000,
        __DS0Core,

That way everything worked fine !

Thank you !