Error 429 "Too many Requests" integration between Power BI and RepairShopR

[NeilChadwick]

Hi I get the infamous error 429 when I automatically or manaully trigger a dataset refresh.  The API error reports ias as follows:

“Web.Contents failed to get contents from 'https://tekstore.repairshopr.com/api/v1/customers?page=60&api_key=T1bd4a1a9dc4e68a64-da731b09bceca14...' (429): Too Many Requests. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.”

This seems to have geenreted several threads but I don't see a definitive fix.  Is there not a way to slow the rate of requests made?

[v-mengzhu-msft]

Hi @NeilChadwick ,

When a user tries to perform too many requests in a particular time-frame, A 429 ‘Too Many Requests’ error befalls. This error is triggered based on the certain rate-limiting settings that a service provider’s servers put in place.  Like this:

Generally, we use the following two rate-limiting methods:

1 One method is Rate limiting per user agent to preserve from bots and crawlers that are wearing out server resources, and

2 Rate limiting per IP to protect from hackers, SEO analyzers and testing devices.

How to resolve 'too many requests' error from the server? (apachebooster.com)

Best regards,

Community Support Team Selina zhu