'Too many requests' error on InvoiceLinesFlat

I’m unable to understand the question. The normal operation of the chain involving Power BI, Teamleader and Invantive Cloud is as follows:

  • Power BI requests a dataset from Invantive Cloud
  • Invantive Cloud returns the data from cache if already available, otherwise it sends a request to the Teamleader Focus APIs where needed
  • The Teamleader Focus API returns the response, which Invantive Cloud passes back to Power BI.

The initiative for requests always follows this path: Power BI > Invantive Cloud > Teamleader Focus API.

Note that InvoiceLinesAll can perform 1 API call per invoice. With 10,000 invoices (without filtering), this can result in 10,000 API requests to Teamleader Focus.

Should you encounter “too many requests”, we advise you to have a look at the information at: