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...
Anonymous
I opened a ticket with MS support and not yet have any solution or workaround for this case.
I want to add something on this case:
1, This issue currently looks like only occured on sharepoint online list 2.0 connector. 1.0 or sharepoint list is ok for Power BI datasoucre.
2, The issue is not happend on the list items once hitting the 5k. for my scenario, one of my list is reach to 22000 itmes then Power BI starting refresh failed with 500 internal server error. and antoher list just reach to 13000times then got the refresh issue.
after that I have to delete the items below than 5K, Refresh worked again and once hitting the 5K the refresh failed again.