PBI refresh error, Sharepoint List, DataSource.Error: Web.Contents failed to get contents (500)

[skip2mylou]

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')/...' (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')/...

[Anonymous]

Hi @skip2mylou ,

You can navigae to it directly through the SharePoint site to ensure that the SharePoint list is accessible and not corrupted.
The error message you gave is not complete, you can see a more detailed error message in M editor, such as the one mentioned in this case:
Solved: DataSource.Error Web.Contents failed to get data f... - Microsoft Fabric Community

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[skip2mylou]

Hi Dino,

Thanks for the reply. The post you shared was talking about the old SharePoint List connector. I need to use the 2.0 connector because my List is quite big. I can also be sure that there's no special characters for the SharePoint site, and list. 
Could you be more specific on how to ensure the SharePoint list is accessible and not corrupted?

FYI, my solution is to duplicate the corrupted List, reload all data, and it works.

June

[Anonymous · Accepted solution]

Hi @skip2mylou ,

After testing by our engineers, we have confirmed that this is a known issue. 
When connecting to SharePoint list below by using SharePoint list connector 2.0 in power bi desktop. Then issue will occur.
If there is any follow up on this issue, I will be the first to respond here.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @skip2mylou 

Could it possibly be that there was just a temporary issue, if you had to change it back could it then be working?

[skip2mylou]

Hi Gilbert, 

Thanks for the reply. I wish it's temporary. It's still throwing the same error just now, so I have this problem for 40 hours.😢