Forum Discussion
SharePoint: Request failed: The remote server returned an error: (429). (429 TOO MANY REQUESTS)
Hello,
I have a report which has data source from Share Point Library. And have schedule refresh for 8 times a day. It was working fine from begining of this year since I created. But for last couple of days it gives me an error as shown below.
Can someone help me to resolve this.
Thank You.
8 Replies
The sharepoint server tells you to slow down and send fewer requests, with bigger intervals between them/ Check if you have a rogue process somewhere that is bombarding the sharepoint server with requests.
Instead of scheduling it consider to trigger the refresh requests based on events. As a matter of fact, Sharepoint based data sources are automatically refreshing the dataset "within the hour" (allegedly, according to Microsoft).
Hi EbyEaso ,
When the user sends too many requests within a given time or get throttled in SharePoint Online, maybe cause this error:
workaround1:
It is recommended that you put all upload tasks in a console application and schedule the upload frequency within a certain interval of the code logic, which may help reduce the burden on the client and server machines.
workaround2:
advise you to stagger your jobs and to make sure that an appropriate interval is used so that one job can finish before the next one starts.
Here is the reference document link:Avoid getting throttled or blocked in SharePoint Online
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.This report is made out from Power BI. So you mean i neeed to give more intervals between each refresh? Currently I set 1 or 2 hrs between each refresh.
