Forum Discussion
How to enable scheduled refresh for a large SharePoint list?
This is for a SharePoint Online list. It has more than 20K items and approximately 50-100 items are created/modified each day. I'd like to be able to refresh the Power BI report that references this list at least twice per day if possible.
I've never heard anything about the Power BI service refreshing SharePoint lists within the hour. It's my understanding that data models only refresh if you turn on the scheduled refresh feature in the dataset's settings.
As far as business value, we have lots of different SP lists that we're using in different PBI data models. As more and more of these become "large" lists, it'll be more and more important for me to understand how to create a query that can auto-refresh and provide updates on large lists.
Please let me know if further clarification will help.
Super UserYou may also want to consider looking at it from the other side (ie from the Power BI Service)
Create a semantic model from a SharePoint List - Power BI | Microsoft Learn