Power BI Connector for Shopify

Build 25.0.9454

DraftOrderTaxLines

Lists tax components applied to draft orders, including rate and tax jurisdiction.

View-Specific Information

Select

The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.

  • ResourceId supports the '=, IN' comparison operators.

For example, the following query is processed server-side:

  SELECT * FROM DraftOrderTaxLines WHERE ResourceId = 'Val1'

Columns

Name Type References Description
Title [KEY] String The display name of the applied tax, such as 'VAT' or 'Sales Tax'.
ResourceId [KEY] String

DraftOrders.Id

A globally unique identifier for the tax record associated with the draft order.
Source String Indicates the origin or provider of the tax calculation, such as Shopify, a third-party app, or an external tax service.
Rate Double The tax rate applied to the line item, expressed as a decimal value (for example, 0.07 for a 7% tax rate).
ChannelLiable Bool Specifies whether the sales channel that submitted the draft order is responsible for remitting the tax. A null value indicates that the liability status is unknown.
RatePercentage Double The tax rate expressed as a percentage of the line item's price (for example, 7.0 for 7%).
PriceSetPresentmentMoneyAmount Decimal The total tax amount for the line item in the customer's presentment currency.
PriceSetPresentmentMoneyCurrencyCode String The ISO currency code representing the presentment currency for the calculated tax amount.
PriceSetShopMoneyAmount Decimal The total tax amount for the line item in the shop's primary currency.
PriceSetShopMoneyCurrencyCode String The ISO currency code representing the shop's currency for the calculated tax amount.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454