Forum Discussion

HaiVN's avatar
HaiVN
Icon for Helper III rankHelper III
6 months ago
Solved

Updating 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...
  • Natarajan_M's avatar
    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