Forum Discussion
Incremental refresh in SharePoint online
Hi All,
I have been trying to configure incremental refresh for my Power BI report which is connected to SharePoint online. I have configure the parameters range start and range and in my power query and filtered the date time column as required. When I upload in Power BI service the scheduled refresh fails throwing an error
"<pii>DataSource.Error: <pii>SharePoint</pii>: Request failed: <pii>The remote server returned an error: (429). (429 TOO MANY REQUESTS)</pii>. DataSourceKind = <pii>SharePoint</pii>."
So when I checked few discussions in the forum and found the parameters in service it is empty.
Kindly help understand/ resolve tthis issue.
Thanks.
7 Replies
- lbendlin
Super User
That's not the problem. The problem is that you are bombarding the sharepoint with too many API calls.
Are you running this against a Sharepoint List? If so, how many rows are in that list? Incremental refresh is usually only necessary when you have more than a million rows. Sharepoint lists usually fall over when they have more than 5000 rows.
Hi Ibendlin,
Thanks for the response.
You are correct. I am running it on a SharePoint list(s). Totally i have connected 5 lists in the report.
List 1 contains more than 85000 items,
List 2 contains more than 10000 items,
List 3,4,5 contains less than 5000 items.
I have configured incremental refresh in all the lists in the report.
So does this cause too many API calls and is the SharePoint row limit issue is causing this?
- lbendlin
Your immediate issue is too many API calls. The row count issue will bite you later.
Try using ODATA queries instead.
