DataSource.Error: Web.Contents failed to get contents

[Anonymous]

Hi Everyone,

I'm trying to connect to a SharePoint online list with 90K+ rows using V2 connector but I'm getting the below error

DataSource.Error: Web.Contents failed to get contents from 'https://XXX.sharepoint.com/sites/XXX/_api/Web/Lists(guid'564b76c0-1800-4fcc-973a-f6200185e0fe')/RenderListDataAsStream' (500): Internal Server Error
Details:
    DataSourceKind=SharePoint
    DataSourcePath=https://XXX.sharepoint.com/sites/SSS
    Url=https://XXX.sharepoint.com/sites/XXX/_api/Web/Lists(guid'564b76c0-1800-4fcc-973a-f6200185e0fe')/RenderListDataAsStream

This doesn't happen when I use V1 connected, however, it's too slow and can take up to 4 ~ 5 hours. 

[Anonymous · Accepted solution]

Thanks for sharing.
The solution you've shared didn't work for me. While troubleshooting I've created a new SP view for my list and strangly enough, it worked!!

[v-yalanwu-msft]

Hi, @Anonymous ;

Get data from SharePoint lists with lots of items can be frustratingly slow.
Please see this blog/video for another (and much faster) way to pull in SharePoint list data.

Get Data From SharePoint Lists … But Fast – Hoosier BI

PowerBI and Sharepoint Online List - Web.Contents ... - Power Platform Community (microsoft.com)

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@Amratya