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 ,
It both got error on desktop and Power BI service. and once I removed sharepoint list items less than 5000 rows and then it can be refresh again.
and I noticed that the issue happend on datasource connecter is sharepoint online list, 2.0. 1.0 or sharepoint list is no problem.
DatasourceConnecter: sharepoint online list, 2.0
Source = SharePoint.Tables("https://XXXXXXXXX", [Implementation="2.0", ViewMode="All"]),