Most RecentNewestMost VotedMost ViewedSet up a data connection in Power BI for Sharepoint Hello team how are you doing, I'm trying to set up a data connection in Power BI for sharepoint and I'm getting the error listed above, wondering if you have any inputs and/or feedback about this matter? Thank you so much SolvedPBI refresh error, Sharepoint List, DataSource.Error: Web.Contents failed to get contents (500) I have a sharepoint list that being imported to PowerBI dataset with over 40000 items and have had no problem to refresh until yesterday. I got this error message when refresh both in Service and PBIdesktop. Changed to Sharepoint Online List connector 1.0 the problem solved, but it takes forever to load, weirdly loading way bigger than the actually size of the list. What could be the problem? Is it like one person on this site said the SharePoint List is corrupted? DataSource.Error: Web.Contents failed to get contents from 'https://xxx.sharepoint.com/sites/mysitename/_api/Web/Lists(guid'db53e460-73f6-45f1-846a-xxxxxxxxx')/RenderListDataAsStream' (500): Internal Server Error Details: DataSourceKind=SharePoint DataSourcePath=https://xxxx.com/sites//mysitename Url=https://xxx.sharepoint.com/sites/mysitename/_api/Web/Lists(guid'db53e460-73f6-45f1-846a-xxxxxxxxx')/RenderListDataAsStream Solved
