Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 q...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    Your immediate issue is too many API calls.  The row count issue will bite you later.

     

    Try using ODATA queries instead.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks Ibendlin,

      I will check about ODATA queries and try with that. 

      • Jeovany's avatar
        Jeovany
        New Member
        1 year ago

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