Aug 16 2018 01:12 AM - edited Aug 16 2018 01:12 AM
Hi,
I'm trying to get data into an Excel worksheet from a list in SharePoint Online. I'm doing so through Data tab --> New Query --> From Other Sources --> From SharePoint List
At the beginning, I tried this on a testing subsite within my SharePoint https://mysite.sharepoint.com/testsite and it worked. It returned all the available lists in that subsite and I was able to fetch them into Excel. However, then I created the actual list that I want to import in the main site, which is just https://mysite.sharepoint.com but it always gives an error:
DataSource.Error: SharePoint: Request failed: The remote server returned an error: (500) Internal Server Error.
Details:
DataSourceKind=SharePoint
DataSourcePath=https://mysite.sharepoint.com/_vti_bin/ListData.svc
(basically means it can't find any lists) I've attached a screenshot of the error
So does import data from SharePoint list just works for the subsites?
Aug 16 2018 04:49 PM
Mohammad...are there any clues in the Event Viewer or ULS log? A 500 error is at the IIS level and not SharePoint.
Aug 25 2018 10:08 PM
Thank you Steve for your reply. We are using SharePoint Online so there's no IIS server involved
Aug 26 2018 12:53 PM
Aug 26 2018 12:57 PM