The CData Power BI Connector for OData models OData entities in relational Tables, Views, and Stored Procedures. The table definitions are dynamically obtained from the OData service you connect to. Any changes in the metadata, such as added or removed columns or changes in data type, can be loaded by reconnecting.
The connector models the writable entity sets and singletons described in the service metadata document as bidirectional Tables.
Some OData entities can only be accessed through Navigation Properties. By default, the connector models navigation properties as separate views. You can disable this behavior with NavigationPropertiesAsViews. See Views for more information on querying navigation properties.
Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.