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

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        1 year ago

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