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...
but why get the data from sharepoint online list 1.0 instead of 2.0 is working fine? the same list, 1.0 is working well over 5000 rows even 22000 rows I tried it. but 2.0 doesn't work over 5000 rows.