Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Solved! Go to 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!!
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!!
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.