OData connector -- returns list of tables rather then data from tables

NateBI
NateBI ⚪️
edited November 23 in Connectors

Hi folks,

We have connected to an application DWH using the OData connector. In Domo this connector produces a list of the tables available but not the data from these tables. How do we get the data from specific tables?

My frame of reference here is Power BI which displays a list of tables, once connected, to select and bring into Power Query so looking to achieve this with Domo.

Domo

OData connector

OData details including URL provided by the PPM application.

PBI


All support is appreciated.

Kind regards,

Nathan

Answers

  • NateBI
    NateBI ⚪️
    edited November 23

    Update: Adding the table name to the end of the Odata URL will display the data from that table - included 'value' for the data tag.