Get monday.com API subitems

[leomottarocha]

Hi guys, I have a question.

I'm using the monday API to retrieve the platform data. Recovering the initial data was a piece of cake, but now I face a bit annoying problem. When trying to retrieve the sub-items (child activities) of a project, power bi fails, as it displays the query complexity message and gives a timeout.

Have you ever had this kind of problem?

Is there any way to paginate the queries in power BI and somehow give each query a 5 second pause so as not to time out the monday API's 1 minute timeout?

I'll put here the print of the error and also of my query

Error returned by BI


Query I'm using (I hid my token for security measures)

[leomottarocha]

Hi Ibendlin,
I tried to use this function, but unfortunately it didn't work. Do you have any examples of how it works?

[lbendlin · Accepted solution]

Chris Webb's BI Blog: Simulating Slow Data Sources In Power BI (crossjoin.co.uk)

[leomottarocha]

Wow, I'm so grateful. It worked perfectly, thank you!

[lbendlin]

Read about Function.InvokeAfter()