Forum Discussion
Updating data one after one
- 6 months ago
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. - 6 months ago
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
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.