HubSpot Latest Data Model
The CData Power BI Connector for HubSpot models data from the latest HubSpot CRM API release, currently 2026-09, as an easy-to-use SQL database. There are three parts to the data model: tables, views, and stored procedures.
This schema always targets the newest HubSpot CRM API release. When HubSpot publishes a later release, this schema moves to it, so you do not have to change the Schema connection property to pick up the new version. To stay on a specific release instead, set Schema to that release's schema, such as HubSpot202603.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your HubSpot account. Note that Custom objects are exposed as tables with "__c" appended to the end of the name.
Common tables include:
| Table | Description |
| Contacts | Lists all contacts in HubSpot, supporting both OAuth and private-app token authentication methods. |
| Companies | Lists all company records in HubSpot, supporting both OAuth and private-app token authentication methods. |
| Deals | Lists all deal records in HubSpot, supporting both OAuth and private-app token authentication methods. |
| Leads | Lists all lead records available in HubSpot, supporting lead management workflows. |
| Tickets | Lists all ticket records in HubSpot, supporting both OAuth and private-app token authentication methods. |
| EngagementsCalls | Retrieves all call engagement records in HubSpot, used for tracking customer communication. |
| EngagementsEmails | Retrieves all email engagement records in HubSpot for analyzing customer email interactions. |
| EngagementsMeetings | Lists all meeting engagement records in HubSpot, useful for scheduling and meeting tracking. |
| EngagementsNotes | Retrieves note engagement records in HubSpot, used for logging internal or customer notes. |
| EngagementsTasks | Lists all task engagement records in HubSpot for managing CRM-related tasks. |
| Lineitems | Lists all line item records in HubSpot, supporting both OAuth and private-app token authentications. |
| Products | Lists all product records configured in HubSpot, supporting both OAuth and private-app token authentications. |
| Quotes | Lists all quote records in HubSpot, useful for sales proposal management. |
| Orders | Lists all order records in HubSpot for managing order workflows. |
| Goals | Retrieves all goal records configured in HubSpot, supporting goal tracking and performance management. |
| ContactAssociations | Returns object IDs associated with specific contacts, enabling management of contact relationships to deals and other objects. |
| CompanyAssociations | Returns object IDs associated with specific companies, useful for managing associations to deals and other CRM objects. |
| TicketAssociations | Returns object IDs associated with specific tickets, supporting customer support case associations. |
| DealAssociations | Lists object IDs associated with specific deals, supporting deal-to-object relationships management. |
The connector uses the HubSpot API to process supported filters. The connector processes other filters client-side within the connector.
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard create, read, update, delete (CRUD) operations, including managing OAuth tokens.