Issue with data refresh in Power BI service using OData - Project for the web


We have a report that sources the data from MSSQL and Project web app using OData connector.

Multiple connections are there (more than 10) to access different table from oDAta (Project for the web (PWA).

We started getting error from last week with below description.

Do we have any limitation to connect PWA, as it says TOO Many Requests. Any lead will be appreciated.

DataSource.Error: OData: Request failed: The remote server returned an error: (429). (429 TOO MANY REQUESTS). DataSourceKind = OData. DataSourcePath…

Below, smoe links tried

Solved: OData: Request failed: The remote server returned … - Microsoft Power BI Community

Avoid getting throttled or blocked in SharePoint Online | Microsoft Learn


Bumping this post for more visibility from our experts and users.

Hi @sschaefer

We have noticed that your inquiry has remained unresolved for an extended period of time, indicating that it may have been outside the capabilities of our experts and users.

If you believe that you have provided all the necessary context for your concerns and have familiarized yourself with effective forum usage by referring to this guide, we recommend exploring the additional resources included with your subscription. These resources can provide valuable assistance with your Power BI education, and we encourage you to utilize them.

While our users and experts strive to assist with inquiries to the best of their abilities, it is important to acknowledge that not all concerns can be addressed, particularly when there are valuable learning opportunities involved. Thank you for your understanding.

We sincerely hope that you find the solution you are seeking and achieve your desired outcome.