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.
Hi @EbyEaso ,
When the user sends too many requests within a given time or get throttled in SharePoint Online, maybe cause this error:
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.
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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
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.
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).
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.
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.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.