Data Query from a parent SharePoint Online Site

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?