Forum Discussion
Can't load SharePoint list: RenderListDataAsStream' (500): Internal Server Error
Today I got this error messgae. How to solve it? Now we have 5,xxx rows in sharepoint list DataSource.Error: <ccon>Web.Contents failed to get contents from 'https://xx.sharepoint.com/sites/xx/_api/W...
I don't think the issue is only limited to the fact the list has gone over 5000 items. I have one Power BI report that collects data from 5 different SharePoint lists, all using v2 of the connector. Two of these lists have over 50,000 entries, with around 20 columns, most with data, so it's a huge list. Power BI has no problem retrieving data from these lists.
Yesterday, one of the other lists went over 5000 entries, and now Power BI is complaining... I checked everything, and all lists are being retrieved in an identical form: using the same v2 connector, no filters, nothing...
I literally have no idea what the problem is or how to fix it, but having two huge lists syncing without a problem tells me it is possible to get this to work!