Forum Discussion
DataSource.Error Web.Contents failed to get data from (500): Internal Server Error
Hi everyone,
When I'm trying to import my data from SharePoint online List I'm getting this error:
Spoiler
DataSource.Error: Web.Contents failed to get contents from
'https://xxxxx.sharepoint.com/sites/xxxxx/_api/Web/Lists(guid'xxxxxxxxxxxxxxxx')/RenderListDataAsStream' (500): Internal Server Error
Details:
DataSourceKind=SharePoint
DataSourcePath=https://xxxxxx.sharepoint.com/sites/xxxxxxxxxx
Url=https://xxxxxxx.sharepoint.com/sites/xxxxxxxxxxx/_api/Web/Lists(guid'374b907e-cddf-4ed7-xxxxxxxxxxxx')/RenderListDataAsStream
'https://xxxxx.sharepoint.com/sites/xxxxx/_api/Web/Lists(guid'xxxxxxxxxxxxxxxx')/RenderListDataAsStream' (500): Internal Server Error
Details:
DataSourceKind=SharePoint
DataSourcePath=https://xxxxxx.sharepoint.com/sites/xxxxxxxxxx
Url=https://xxxxxxx.sharepoint.com/sites/xxxxxxxxxxx/_api/Web/Lists(guid'374b907e-cddf-4ed7-xxxxxxxxxxxx')/RenderListDataAsStream
and here below the M editor
Spoiler
let
Source = SharePoint.Tables("https://xxxxx.sharepoint.com/sites/xxxxxxxxx", [Implementation="2.0", ViewMode="All"]),
#"374b907e-cddf-4ed7-xxxxxxxxxxxx" = Source{[Id="374b907e-cddf-4ed7-xxxxxxxx"]}[Items]
in
#"374b907e-cddf-4ed7-xxxxxxx"
Source = SharePoint.Tables("https://xxxxx.sharepoint.com/sites/xxxxxxxxx", [Implementation="2.0", ViewMode="All"]),
#"374b907e-cddf-4ed7-xxxxxxxxxxxx" = Source{[Id="374b907e-cddf-4ed7-xxxxxxxx"]}[Items]
in
#"374b907e-cddf-4ed7-xxxxxxx"
I can open the sharepoint list itself properly without any problems.
Able to fetch restricted data using "Implementation=2.0" and "ViewMode=Default" and in "Implementation=1.0"
But require this particular list in "Implementation=2.0" and "ViewMode=All" as more data can be accessed for the report.
2 Replies
What is the authenticaion method you are using to get data from Sharepoint Online ? Make sure that Privacy Level is selected to "None" at Data source level
