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/Web/Lists(guid'xx')/RenderListDataAsStream' (500): Internal Server Error.
2 Replies
Hi nirun00s
The error started after the sharepoint list had more than 5k items . You can use the Power BI 2.0 connection to SharePoint was to leverage paging and avoid issues like this .
Solved: Error Connecting to SharePoint List (500): Interna... - Microsoft Power BI Community
Solved: SharePoint Online Lists 2.0 (Beta) - Microsoft Power BI Community
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.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!
