Tables
The connector models the data in Avalara as a list of tables in a relational database that can be queried using standard SQL statements.
CData Power BI Connector for Avalara Tables
| Name | Description |
| Accounts | Accounts table for AvalaraAvatax data provider. |
| Batches | Batches table for AvalaraAvatax data provider. |
| Companies | Companies table for AvalaraAvatax data provider. |
| Contacts | Contacts table for AvalaraAvatax data provider. |
| Customers | Customers table for AvalaraAvatax data provider. |
| DataSources | DataSources table for AvalaraAvatax data provider. |
| DistanceThresholds | DistanceThresholds table for AvalaraAvatax data provider. |
| FilingCalendars | FilingCalendars table for AvalaraAvatax data provider. |
| Items | Items table for AvalaraAvatax data provider. |
| Locations | Locations table for AvalaraAvatax data provider. |
| MultiDocument | MultiDocument table for AvalaraAvatax data provider. |
| Nexus | Nexus table for AvalaraAvatax data provider. |
| Notices | Notices table for AvalaraAvatax data provider. |
| Notifications | Notifications table for AvalaraAvatax data provider. |
| Settings | Settings table for AvalaraAvatax data provider. |
| TaxCodes | TaxCodes table for AvalaraAvatax data provider. |
| TaxRules | TaxRules table for AvalaraAvatax data provider. |
| TransactionLines | TransactionLines view for AvalaraAvatax data provider. |
| Transactions | Transactions table for AvalaraAvatax data provider. |
| Upcs | Upcs table for AvalaraAvatax data provider. |
| Users | Users table for AvalaraAvatax data provider. |