Forum Discussion
Web.Contents could not get the content - Error Data Source
Hello,
I have a problem today when refreshing a dataset in Power BI Service.
This one tells me: Web.Contents could not get the content of 'my.sharepoint.com/sites/xxxxxxx/_api/web/getfilebyserverrelelivivell('/sites/xxxxxxxxx/Documents%20parties/ value '(500): Internal server error The exception was triggered by the IDbCommand interface Table: START.
I have Excel files on Sharepoint where there is new data but have not changed format ...
Whenever I update, the error is not on the same file.
Any ideas ?
Need Help
3 Replies
in power bi desktop i have this message :
DataSource.Error : SharePoint: Request failed : partages/0 - ORIGINE/2019/E@sy_Board_ 0'_v15-3-4-2019_csv/_api/contextinfo
Détails :
DataSourceKind=SharePoint
DataSourcePath= //xxxx.sharepoint.com/sites/msceasyboardgrpo365
SPRequestGuid=5352199f-50d7-a000-7ca7-3fae92d40b60Hi Anonymous ,
You may use web connector to connect the excel files in Power BI Desktop.
In your scenario, please firstly go to File->Options and Settings->Data Source Settings->Global permissions in Power BI Desktop and clear permissions for stored SharePoint data source.
Secondly, to connect to Excel that is located under Documents of SharePoint online site, please use the URL below.
https://xxxxx.sharepoint.com/sites/<sitename>/Shared%20Documents/<Yourexcename>.xlsx
To connect to Excel that is located under a folder in SharePoint online Documents, please use the URL below.
https://xxxxx.sharepoint.com/sites/<sitename>/Shared%20Documents/<Foldername>/<Yourexcename>.xlsx
However, if you want to connect to SharePoint online folder in Power BI Desktop, please use SharePoint Folder connector and use the URL below, and use organizational account method.
https://xxxxx.sharepoint.com/sites/<sitename>
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
