Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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')/RenderListData...' (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')/RenderList...
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],
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
It appears that this is a server side issue.
As it says in the message - 500 is an internal error on the sharepoint. Are you overwhelming the server with too many concurrent requests?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 7 | |
| 7 | |
| 5 | |
| 4 | |
| 3 |
| User | Count |
|---|---|
| 14 | |
| 14 | |
| 10 | |
| 8 | |
| 8 |