datasource: sharepoint list Power BI desktop use sharepoint online list 2.0 to get the data. When sharepoint list itmes over than 5000. the power bi couldn't refresh. as below error Web.Con...
Hi henryzf
The reason why Microsoft placed the 5,000 limit threshold — to maintain the performance of the server and enable users to access the library without waiting for hours. You can get a better understanding of SharePoint 5,000 Item Limit Threshold by following this article .
https://www.mrsharepoint.guru/resolve-the-sharepoint-item-limit-threshold/
Best Regards,
Community Support Team _ Ailsa Tao