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

[SujoyDasgupta]

Hi All,

I have published a power BI report and scheduled a auto refresh daily 4 times. Schedule refreshing working fine but every alternate day once schedule refresh fail. I dont know how to resolve this issue.

I am showing data from SharePoint list. 

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

Thank you in advance.

[v-henryk-mstf]

Hi @SujoyDasgupta ,

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 | Microsoft Docs

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.

[SujoyDasgupta]

Hi @v-henryk-mstf  & @collinq ,

Thank you for your response.

I have schedulled the refresh after every 4 hours and I am getting the data from the SharePoint's Multiple list. The sharePoint list don't have much data. Maximum 3000 to 4000 list item.

 I am still facing the same issue. I have faced below different type of error:

• SharePoint: Request failed: The remote server returned an error: (429). (429 TOO MANY REQUESTS)
• Timeout expired. The timeout period elapsed prior to completion of the operation.
• The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

Need Help

Thanks

[collinq]

Hi @SujoyDasgupta ,

Check this thread out and let us know if that helps resolve your issue:

Power BI Scheduled Refresh Failure Error: 429 TOO ... - Microsoft Power BI Community