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

NateBI
NateBI Member
edited November 2022 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

image.png

OData details including URL provided by the PPM application.

image.png

PBI

image.png


All support is appreciated.

Kind regards,

Nathan

Best Answer

  • NateBI
    NateBI Member
    edited November 2022 Answer ✓

    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.

Answers

  • NateBI
    NateBI Member
    edited November 2022 Answer ✓

    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.

Categories