DataSource.Error: <ccon>Web.Contents failed to get contents from Sharepoint
Since last monday night, all of my power bi's published on power bi service that used to refresh during the night started to fail and return the error:
- Data source errorDataSource.Error: <ccon>Web.Contents failed to get contents from 'htt ps :// XXXXXX .sharepoint/(...)
This type of connections is working on power query for excel.
It works when I refresh query by query on the power bi desktop
but doesnt work on the power bi service and aldo with I try to "refresh all" on power bi service.
My company has no other solution than sharepoint.
Is this happening with someone else?
17 Comments
- AnonymousNot applicable
Hi IzaLeo ,
For the time being, there is no feedback from other users who have encountered similar experiences as you. We have not been able to reproduce this problem, during our investigation we found that some solutions have been shared by users in the past, please check if they are helpful to you.
Solved: DataSource.Error Web.Contents failed to get data f... - Microsoft Fabric Community
Best regards.
Community Support Team_Caitlyn - IzaLeo
Advocate I
Hello,
I did try this , but it did not work.
Thanks anyway. - IzaLeo
Advocate I
- This is the complete error
Data source errorDataSource.Error: <ccon>Web.Contents failed to get contents from 'https://XXXX.sharepoint.com/sites/XXXX/_api/web/lists/getbyid('48524f1f-3379-44d2-8ead-5d6516856a2a')/RenderListDataAsStream?Paged=TRUE&p_SortBehavior=0&p_ID=841042&ix_Paged=TRUE&ix_ID=841042&PageFirstRow=18648' (429): . DataSourceKind = SharePoint. DataSourcePath = https://XXXX.sharepoint.com/sites/XXXX. Url = https://XXXX.sharepoint.com/sites/XXXX/_api/web/lists/getbyid('48524f1f-3379-44d2-8ead-5d6516856a2a')/RenderListDataAsStream?Paged=TRUE&p_SortBehavior=0&p_ID=841042&ix_Paged=TRUE&ix_ID=841042&PageFirstRow=18648. </ccon>. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: XXXX. - Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net
- Activity ID4dce30e7-8c79-44a2-a4f1-f1f071fde49b
- Request IDaf2decbb-8078-4ab8-9065-5ddcf508f861
- Time2023-05-24 22:24:11Z
- This is the complete error
- joelzehringFrequent Visitor
We're seeing a similar issue with datasets connected to SharePoint. It appears to be a recent issue. The error message includes "429" which is a common HTTP error code indicating "Too many requests".
- MagdaMarcRegular Visitor
We're also experiencing the same issue from Tuesday. Error "429" with datasets connected to SharePoint.
- ihyiukhkjuhRegular Visitor
I have also the same issue.
- FadyNRegular Visitor
We are expericing same error 429 impacting 6 different reports and datasets since Wednesday
- IzaLeo
Advocate I
Om my side, it's happening with all of my report, since they are all connected to sharepoint, since Tuesday.
- YD-BIFrequent Visitor
Hello,
Same issue here (with error code 429) regarding all my datasets linked to my SharePoint: every scheduled refresh gets the issue, manual refresh about half the time; if I refresh from Desktop, things are better but not always working.
I read the 429 error code is usually related to too many request being received, asmentioned by another user, however for me we are talking only about 10 datasets with one scheduled refresh per day... and it didn't change in the last few days.
- IzaLeo
Advocate I
Same here, the schedule refresh is to 1 report per hour, where each report contains 4 querys.
Until Monday this used to run smoodly every night, for the last year.