SOAP Data Model
The CData Power BI Connector for PayPal models the PayPal SOAP APIs as database Views. Typically, read-only data are shown as views. These are defined in schema files, which are simple, text-based configuration files that make schemas easy to customize.
This section provides the API limitations and requirements for the SOAP data model; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.
Collaborative Query Processing
The connector offloads as much of the SELECT statement processing as possible to the PayPal APIs and then processes the rest of the query within the connector.
See SupportEnhancedSQL for more information on how the connector circumvents API limitations with in-memory client-side processing.
Views are tables that cannot be modified. Typically, read-only data are shown as views.