Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

DataSource.Error: Web.Contents failed to get contents

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. 

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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!!

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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
Community Support
Community Support

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
Not applicable

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!