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...
I am also experiencing the same issue for one of my lists. This was previously working prior to hitting the 5k item count. Since then it seems to work sporadically if I make changes to the view.
I have other lists which are well above 5k and have been for some time. Their list settings are identical and the connection within PowerBI are also identical. Yet PowerBI can connect to these lists without an issue.
There seems to be no consistency here. Could someone shine some light on this please?