When using the OData protocol, you can access only data defined within Excel tables in the spreadsheet, which you create by clicking Insert -> Table in Excel.

Therefore if you have data outside a table object, this data cannot be retrieved using the OData API. Thus you may see a case where no tables are returned. This is a function of the OData API and you may want to look at using the REST API in such a case.