search

SharePoint / sp-dev-docs

SharePoint & Viva Connections Developer Documentation
https://docs.microsoft.com/en-us/sharepoint/dev/
Creative Commons Attribution 4.0 International
1.25k stars 1.02k forks source link

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

Open Cheryl195 opened 2 years ago

Cheryl195 commented 2 years ago

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

Additional environment details

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.

ghost commented 2 years ago

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

CallumCrowley commented 2 years ago

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