429 TOO MANY REQUESTS dataflow

[Anonymous]

Hi Community,

I am getting a 429 TOO MANY REQUESTS error from refreshing a dataflow.  I asked one of co-worker to take over the dataflow and refresh it and it worked for him.

I am curious to know if sharepoint is using some quota counter on given user and is there anyway we can change it?  If yes, what is the reset duration and what is the counter value?

Secondly, I took over the dataflow again the next day and refreshed it, it refreshed fined, but when I am tried to put an incremental refresh and refresh the dataflow again, it failed.  Then, upon removing the incremental refresh, it refreshed again fine.  So, is there any reason that incremental refresh is not working for this dataflow.  (I am using modified column from SharePoint list for incremental refresh.)

Finally, I see Oauth2 being used in data source credentials option in the dataflow settings.  Can anyone explain what type of Oauth2 grant type we are using here?

Regards

Sabyasachi

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

Normally this error comes when you try to request more than 1 request in 1 second.

So the thing you can do is go through Avoid getting throttled or blocked in SharePoint. It may give you the basic idea behind this error and you may find out why this error is generated.

And you could read the following article ,wish it could help you!

datasource.error: sharepoint: request failed: the remote server returned an error: (429)

429 Error SharePoint List Source

SharePoint 429 Error - Throttling

Best Regards

Lucien