Forum Discussion
Helper IIIUpdating data one after one
I have a power bi report which gets 15 data tables via APIs from a website. We have problem 'HTTP-429 , too many request ' when we update the report. The website has a limit of 20 callings per minute. And it is the problem with my report. Is anyone has experience to set the updating which run at each table ( one after one). I mean the next data table will run after it gets the information on the table before it has finised updating? I have set the report to 'no parallel updating".
Thank you!
Hi HaiVN
A long time ago I had a similar problem and I believe it was solved with Function.InvokeAfter.
Please check the comments under this thread: http://community.fabric.microsoft.com/t5/Desktop/Need-a-Sleep-or-Wait-step-in-my-Query-hitting-API-rate-limits/m-p/85831
You could configure your queries with delays such that you never go over the limit.Hi HaiVN , Power BI refresh logic by default handled by the internal engine , where it deceides which all are the table that be refreshed in parallel .
example if you have a query 2 which is using another query 1 as reference then the query 2 will be executed after query 1 .
the best approach is using a power shell script or fabric pipeline to refresh the table in sequence this will give you the control you want .
else try checking the reference pattern which i mentioned above
Thanks
4 Replies
- dk_dk
Super User
Hi HaiVN
A long time ago I had a similar problem and I believe it was solved with Function.InvokeAfter.
Please check the comments under this thread: http://community.fabric.microsoft.com/t5/Desktop/Need-a-Sleep-or-Wait-step-in-my-Query-hitting-API-rate-limits/m-p/85831
You could configure your queries with delays such that you never go over the limit. - Natarajan_M
Hi HaiVN , Power BI refresh logic by default handled by the internal engine , where it deceides which all are the table that be refreshed in parallel .
example if you have a query 2 which is using another query 1 as reference then the query 2 will be executed after query 1 .
the best approach is using a power shell script or fabric pipeline to refresh the table in sequence this will give you the control you want .
else try checking the reference pattern which i mentioned above
Thanks 
v-pnaroju-msftCommunity Support
Thankyou, dk_dk and Natarajan_M for your responses.
Hi HaiVN,
We appreciate your inquiry through the Microsoft Fabric Community Forum.
We would like to inquire whether have you got the chance to check the solutions provided by dk_dk and Natarajan_M to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.
Thank you.- v-pnaroju-msft
Hi HaiVN,
We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.
Thank you.