Power BI Connector for Adobe Commerce

Build 23.0.8839


CustomerAddress is an auto generated table. The supported operations are Delete, and Querying data from this table.

Table Specific Information


The 本製品 will use the AdobeCommerce API to filter the results by AddressId while the rest of the filter is executed client side within the 本製品.

The AddressId column must be specified in the WHERE clause to retrieve results from CustomerAddress. AddressId can be used only with the equals (=) operator. For example:

SELECT * FROM [CustomerAddress] WHERE AddressId = '123'


Name Type ReadOnly Description
Id [KEY] Int False


AddressId String False


City String False

City name

Company String False


CountryId String False

Country code in ISO_3166-2 format

CustomerId Int False

Customer ID

DefaultBilling Bool False

If this address is default billing address

DefaultShipping Bool False

If this address is default shipping address.

ExtensionAttributes String False

This is an auto-generated column

Fax String False

Fax number

Firstname String False

First name

Lastname String False

Last name

Middlename String False

Middle name

Postcode String False


Prefix String False


Region String False

This is an auto-generated column

RegionId Int False

Region ID

Street String False


Suffix String False


Telephone String False

Telephone number

VatId String False

Vat id

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839