Error: 429 TOO MANY REQUESTS - Sharepoint site connection fails from Power BI scheduled refresh

[Cheryl195]

Target SharePoint environment

SharePoint Online

What SharePoint development model, framework, SDK or API is this about?

SharePoint REST API

Developer environment

Windows

What browser(s) / client(s) have you tested

• 💥 Internet Explorer
• 💥 Microsoft Edge
• 💥 Google Chrome
• 💥 FireFox
• 💥 Safari
• mobile (iOS/iPadOS)
• mobile (Android)
• not applicable
• other (enter in the "Additional environment details" area below)

Additional environment details

• browser version

Describe the bug / error

I am experiencing an issue that results with an error "429 Too Many Requests" that is running on a schedule from Power BI. This Power BI Workspace has many connections to a SharePoint site that has the data stored. These reports have been running just fine for months and months and now we have an issue. Did something change in SharePoint that I need to know about? Why would this just start happening?

Steps to reproduce

1. Power BI schedule triggers the dataset to update (is at 7:00am)
2. data is stored inside a SharePoint site
3. Error occurs and email is sent to owner of dataset.
4. OData: Request failed: The remote server returned an error: (429). (429 TOO MANY REQUESTS)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"OData"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"https://rsmnet.sharepoint.com/sites/pwa_it/_api/ProjectData/_api/ProjectData/AssignmentTimephasedDataSet"}},
   :{"type":1,"value":"https://rsmnet.sharepoint.com/sites/pwa_it/_api/ProjectData/_api/ProjectData/AssignmentTimephasedDataSet?$filter=TaskIsActive eq true and TimeByDay ge datetime'2020-05-01T00:00:00

Expected behavior

expect the dataset in Power BI to be refreshed with new data from SharePoint site.

Thank you for reporting this issue. We will be triaging your incoming issue as soon as possible.

[CallumCrowley]

Have you checked the Avoid getting throttled or blocked in SharePoint Online advice?

[github-actions]

Thank you for taking the time to file an issue. We periodically archive older or inactive issues as part of our issue management process, which automatically closes them once they are archived.

If you’d like to understand more about why and how we handle archived (closed) issues, please see Our approach to closed issues.

We appreciate your contribution and if this is still an active issue with the latest SPFx versions, please do resubmit the details. We needed to perform a cleanup, so that we can start with a clean table with a new process. We apologize for the inconvenience this might cause.