Power BI Connector for Shopify

Build 25.0.9454

ShopifyPaymentsAccount

Returns Shopify Payments account details, including balances, disputes, and payouts.

View-Specific Information

Select

The connector processes all filters client-side within the connector. The following query is the only one processed server-side:

  SELECT * FROM ShopifyPaymentsAccount

Columns

Name Type References Description
Id [KEY] String A globally unique Id for the Shopify Payments account.
Activated Bool Indicates whether the Shopify Payments setup is completed.
Country String The country associated with the Shopify Payments account.
Onboardable Bool Indicates whether the Shopify Payments account can be onboarded.
DefaultCurrency String The default payout currency for the Shopify Payments account.
PayoutStatementDescriptor String The descriptor used for payouts. This text appears on the merchant's bank statement when they receive a payout.
PayoutScheduleInterval String The interval at which payouts are sent to the connected bank account.
PayoutScheduleMonthlyAnchor Int The day of the month funds are paid out. Accepts values from 1–31. If set to monthly, payouts scheduled on the 29th–31st are sent on the last day of shorter months.
PayoutScheduleWeeklyAnchor String The day of the week funds are paid out. Accepts values from Monday to Friday. Used when the payment interval is set to weekly.

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