The CData Power BI Connector for Shopify models entities in the Shopify API as an easy-to-use SQL database, using tables, views, and stored procedures. These are defined in schema files, which are simple, easy-to-read text files that define the structure and organization of data.

The driver exposes two schemas, which you select in Schema:

• See REST Data Model for the available entities in the REST API Version 2025-04.
  • Note: As of October 1, 2024, Shopify has designated the REST API as legacy.
• See GRAPHQL Data Model for the available entities in the GraphQL API Version 2025-04.

Note: Shopify typically releases new API versions quarterly. If a stable API version is no longer supported, Shopify automatically defaults to the oldest supported stable version to respond to your API request. For more information on Shopify's API versioning, click this link.

Flexible Schema

The CData Power BI Connector for Shopify is a semi-dynamic driver. This means that it exposes a static schema but can also retrieve dynamic columns from custom fields (for example, in the Products and ProductVariants tables). To enable this feature for either API schema (REST or GraphQL), follow the instructions in IncludeCustomFields. Note that the search for custom fields is limited to 250 rows.