SharePoint Online Lists - Implementation 2.0 Over 5000 records

[Rklearner]

Receiving "DataSource.Error: Web.Contents failed to get contents" error when trying to connect using SharePoint Online List "RenderListDataAsStream' (500): Internal Server Error". I guess the issue is we are having over 5000 records. How do I override this error?

[v-kkf-msft]

Hi @Rklearner ,

Has your problem been solved? If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[pranit828]

Hi @Rklearner 

It is more helpful if you can share the M Code.

Also, try to 

• Delete '[ApiVersion = __]' from the source 
• Add the sharePoint folder link editing in the advanced query editor
• Select through the list of files to the one to be used in the report.

[Rklearner]

I don't see the ApiVersion.

My Code looks like:

let
    Source = SharePoint.Tables("https://xxxxxx.sharepoint.com/sites/CustomerHub/", [Implementation="2.0", ViewMode="All"]),
    #"fdc6dc7f-80f9-45e0-b350-e93e1f714ccc" = Source{[Id="fdc6dc7f-80f9-45e0-b350-e93e1f714ccc"]}[Items],
 #"Added Index" = Table.AddIndexColumn(#"fdc6dc7f-80f9-45e0-b350-e93e1f714ccc", "Index", 1, 1, Int64.Type)
in
    #"Added Index"

[v-kkf-msft]

Hi @Rklearner ,

Please try using an OData connector to directly request the columns from the document library to see if it gets rid of restrictions.

https://<SharePoint Domain>/sites/<Site Name>/_api/web/lists/getByTitle('<SharePoint Library Name>')/items?$select=<Field1>,<Field2>,<LookupField1>/<FieldToBeExpanded1>,<LookupField2>/<FieldToBeExpanded2>&$expand=<LookupField1>,<LookupField2>

For more information, please refer to:

SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error. 

SharePoint list view threshold error when importing fewer than 5000 rows 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.