Forum Discussion
Trouble with Sharepoint online list connection
I have recently been having problems with the connection on one of my reports to a sharepoint online list and being greeted with the below error message;
DataSource.Error: Web.Contents failed to get contents from 'https://xxxxxxxxx.sharepoint.com/sites/xxxxxx/_api/Web/Lists(guid'xxxxxxxxxxxxxxxxx')/RenderListDataAsStream' (500): Internal Server Error
Details:
DataSourceKind=SharePoint
DataSourcePath=https://xxxxxxxxxxx.sharepoint.com/sites/xxxxxxxx
Url=https://xxxxxxxxx.sharepoint.com/sites/xxxxxx/_api/Web/Lists(guid'xxxxxxxxxxxxxxxxxxxxx')/RenderListDataAsStream
The advance editor is below, this was working a month ago before I went on leave and failed while I was away from the office any suggestions on a fix please?
let
Source = SharePoint.Tables("https://xxxxxxxxxxx.sharepoint.com/sites/xxxxxxxx/", [Implementation="2.0", ViewMode="All"]),
#"xxxxxxxxxxxxxxx" = Source{[Id="xxxxxxxxxxxxx"]}[Items],
3 Replies
- lbendlin
Super User
As it says in the message - 500 is an internal error on the sharepoint. Are you overwhelming the server with too many concurrent requests?
v-jingzhangCommunity Support
Hi Anonymous
According to the error message "(500): Internal Server Error ", it looks like not a Power BI or Power Query issue. Maybe it was caused temporarily because of server-side issue.
Does this error still occur now?
Regards,
Community Support Team _ Jing
