Power BI Connector allows selecting the majority of fields and tables from your Shopify store for export into Microsoft Power BI.
Here is the full list of data tables supported by the application:
Balance - The account's current balance. This amount is comprised of any Transaction not yet included in a Payout.
Custom Collections - Represents a custom collection of products. A custom collection is a grouping of products that a merchant can create to make their store easier to browse.
Customers - Represents information about a customer of the shop, such as the customer's contact details, their order history, and whether they've agreed to receive email marketing.
Customers / Email marketing consent
The current email marketing state for the customer.
Field | Description |
|---|
Consent updated at | The date and time at which the customer consented to receive marketing material by email. |
Marketing opt-in level | The marketing subscription opt-in level, as described by the M3AAWG best practices guidelines, that the customer gave when they consented to receive marketing material by email. |
Marketing state | The current email marketing state for the customer. |
Disputes - Disputes occur when a buyer questions the legitimacy of a charge with their financial institution.
Draft Orders - List of saved draft orders. Draft orders are used to create orders on behalf of store customers.
Locations - Represents the location where the physical good resides.
Locations
Represents the location where the physical good resides.
Field | Description |
|---|
Id | A globally-unique ID. |
Activatable | Whether this location can be reactivated. |
Address verified | Whether the location address has been verified. |
Deactivatable | Whether this location can be deactivated. |
Deactivated at | The date and time that the location was deactivated at. |
Deletable | Whether this location can be deleted. |
Fulfills online orders | Whether this location can fulfill online orders. |
Has active inventory | Whether this location has active inventory. |
Has unfulfilled orders | Whether this location has orders that need to be fulfilled. |
Is active | Whether the location is active. |
Legacy resource id | The ID of the corresponding resource in the REST Admin API. |
Name | The name of the location. |
Ships inventory | Whether this location is used for calculating shipping rates. In multi-origin shipping mode, this flag is ignored. |
Locations / Address
The address of this location.
Field | Description |
|---|
First line | The first line of the address for the location. |
Second line | The second line of the address for the location. |
City | The city of the location. |
Country | The country of the location. |
Country code | The two-letter country code of the location. |
Formatted | A formatted version of the location address. |
Latitude | The latitude coordinates of the location. |
Longitude | The longitude coordinates of the location. |
Phone | The phone number of the location. |
Province | The province of the location. |
Province code | The code for the region of the address, such as the province, state, or district. For example QC for Quebec, Canada. |
Zip | The ZIP code of the location. |
Locations / Inventory levels
A list of the quantities of the inventory items that can be stocked at this location.
Field | Description |
|---|
Can deactivate | Whether the inventory items associated with the inventory level can be deactivated. |
Created at | The date and time when the inventory level was created. |
Deactivation alert | Describes either the impact of deactivating the inventory level, or why the inventory level can't be deactivated. |
Updated at | The date and time when the inventory level was updated. |
Locations / Inventory levels / Item
Inventory item associated with the inventory level.
Field | Description |
|---|
Inventory item id | A globally-unique ID. |
Locations / Inventory levels / Location
Location associated with the inventory level.
Field | Description |
|---|
ID | Globally unique ID. |
Activatable | Whether this location can be reactivated. |
Address verified | Whether the location address has been verified. |
Deactivatable | Whether this location can be deactivated. |
Deactivated at | Date and time the location was deactivated (null if location is still active). |
Deletable | Whether this location can be deleted. |
Fulfills online orders | Indicates whether this location can fulfill online orders. |
Has active inventory | Indicates whether or not this location has active inventory. |
Has unfulfilled orders | Indicates whether or not this location has unfulfilled orders. |
Is active | Whether the location is active. |
Legacy resource ID | The ID of the corresponding resource in the REST Admin API. |
Name | The name of the location. |
Ships inventory | Indicates whether or not this location is used for calculating shipping rates. |
Locations / Inventory levels / Quantities
Quantities for the requested names.
Field | Description |
|---|
Name | The name that identifies the inventory quantity. |
Quantity | The quantity for the quantity name. |
Updated at | When the quantity was last updated. |
Locations / Metafields
A list of metafields that belong to the resource.
Field | Description |
|---|
Metafield ID | Globally unique ID. |
Description | The description of a metafield. |
Key | The key name for a metafield. |
Legacy resource ID | The ID of the corresponding resource in the REST Admin API. |
Namespace | The namespace for a metafield. |
Owner type | Owner type of a metafield visible to the Storefront API. |
Value | The value of a metafield. |
Type | The type of data that the metafield stores in the value field. |
Metafields - Metafields represent custom metadata attached to a resource. Metafields can be sorted into namespaces and are composed of keys, values, and value types. This table will include only shop-level meta field data.
Orders - An order represents an agreement to do business between a customer and a merchant. It is a customer's completed request to purchase one or more products from a shop. An order is created when a customer completes the checkout process, during which time they provide an email address or phone number, billing address and payment information.
Payments Transactions - Balance Transactions make up the canonical "statement of account", or ledger for a Shopify Payments account. Every single movement of money in or out of the account is recorded here.
Payouts - Payouts represent the movement of money between a Shopify Payments account balance and a connected bank account.
Products - Contains a shop’s products.
Smart Collections - Represents a smart collection of products. A smart collection is a grouping of products defined by rules that are set by the merchant.
Product Variants - Represents a different version of a product, such as different sizes or differing colours.
Inventory Items - Represents the goods available to be shipped to a customer. It holds essential information about the goods, including SKU and whether it is tracked.
Product Images - All images of all products of the shop.
Fulfillment Orders (*new) - Represents fulfillment orders of merchant-managed and third-party.
Each of these data tables consists of many various fields available for export.