Power BI Connector for TaxJar

Build 21.0.7930

Data Model

Overview

This section shows the available API objects and provides more information on executing SQL to TaxJar APIs.

Key Features

  • The connector models TaxJar entities like documents, folders, and groups as relational views, allowing you to write SQL to query TaxJar data.
  • Stored procedures allow you to execute operations to TaxJar
  • Live connectivity to these objects means any changes to your TaxJar account are immediately reflected when using the connector.

Views

Views describes the available views. Views are statically defined to model Categories, OrderLineItems, and more.

Tables

Tables describes the available tables. Tables are statically defined to model Customers, Orders, Refunds.

Stored Procedures

Stored Procedures are function-like interfaces to TaxJar. Stored procedures allow you to execute operations to TaxJar, including calculating sales tax and validating addresses.

Collaborative Query Processing

The connector offloads as much of the SELECT statement processing as possible to TaxJar and then processes the rest of the query in memory. API limitations and requirements "are also documented in this section.

See SupportEnhancedSQL for more information on how the connector circumvents API limitations with in-memory client-side processing.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930