Forum Discussion
Solved
PowerBI & SharePoint Refresh Speed
I’ve been experiencing some issues with PowerBI dashboards that use SharePoint lists as data sources. The dashboards are taking 5 or 6 hours to refresh. This occurs even after configuring incremental...
This occurs even after configuring incremental refresh, which should only be refreshing around 200 rows in the SharePoint list.Sharepoint is not a foldable data source, there will be no time difference between full and incremental refresh.
Most likely the SharePoint service is throttling the requests from the Power BI Service (via 429). Consider using the Bulk API for SharePoint, or some more targeted OData queries.
Thank you for the advice. Do you have more information on the Bulk API for SharePoint?