topic Re: SharePoint: Request failed: The remote server returned an error: (429). (429 TOO MANY REQUESTS) in Report Server

SharePoint: Request failed: The remote server returned an error: (429). (429 TOO MANY REQUESTS)

EbyEaso — Tue, 06 Sep 2022 03:32:48 GMT

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.

Re: SharePoint: Request failed: The remote server returned an error: (429). (429 TOO MANY REQUESTS)

lbendlin — Wed, 07 Sep 2022 00:19:18 GMT

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.

Re: SharePoint: Request failed: The remote server returned an error: (429). (429 TOO MANY REQUESTS)

v-henryk-mstf — Wed, 07 Sep 2022 01:38:45 GMT

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.

Re: SharePoint: Request failed: The remote server returned an error: (429). (429 TOO MANY REQUESTS)

EbyEaso — Wed, 07 Sep 2022 03:08:24 GMT

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.

Re: SharePoint: Request failed: The remote server returned an error: (429). (429 TOO MANY REQUESTS)

EbyEaso — Wed, 07 Sep 2022 03:08:51 GMT

Re: SharePoint: Request failed: The remote server returned an error: (429). (429 TOO MANY REQUESTS)

EbyEaso — Thu, 08 Sep 2022 05:44:42 GMT

lbendlin

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.

Re: SharePoint: Request failed: The remote server returned an error: (429). (429 TOO MANY REQUESTS)

lbendlin — Thu, 08 Sep 2022 12:23:06 GMT

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).

Re: SharePoint: Request failed: The remote server returned an error: (429). (429 TOO MANY REQUESTS)

EbyEaso — Mon, 12 Sep 2022 03:41:11 GMT

Thank You lbendlin for the comment. But to make that happen to trigger the events I would need Premium rite. Becz Our Share Point library updates every now and then, atleast more than 30+ events happening daily.

Also You mentioned "Sharepoint based data sources are automatically refreshing the dataset "within the hour" (allegedly, according to Microsoft)."

But his wont refresh the report rite. Si still I see issue.

Re: SharePoint: Request failed: The remote server returned an error: (429). (429 TOO MANY REQUESTS)

lbendlin — Mon, 12 Sep 2022 11:07:51 GMT

Reports don't get refreshed. Datasets get refreshed. If a dataset includes a data source on a SharePoint then any changes in that source are - allegedly - reflected in the dataset within the hour automatically. This is independent of any scheduled or API requests from your side.