Incremental refresh in SharePoint online

[Anonymous]

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.

[Anonymous]

Hi, please consider these points.

Be specific about the spelling; it should be 'RangeStart' and 'RangeEnd'

The datatype should be set as 'Date and Time'; only then will it be recognized as a parameter.

[Anonymous]

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.

[Anonymous]

Thanks Ibendlin,

I will check about ODATA queries and try with that. 

[Jeovany]

Any Updates? can you set up incremental refresh on a sharepoint online list? (microsoftList) with more than 5000 items? I can not

[lbendlin]

It's not a foldable source. You will not see any performance advantage.

[lbendlin]

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.