Forum Discussion
HubSpot API Ingestion into PowerBI
I have a user who is using a CDATA ODBC HubSpot connector to ingest certain data into PowerBI. As some of you are aware, this presents a challenge to them when they go on vacation or are away from th...
A HubSpot Certified App is available in the HubSpot App Marketplace for connecting HubSpot to Power BI. There is a free trial.
https://ecosystem.hubspot.com/marketplace/apps/marketing/analytics-data/powerbi
Here is a map of data flow from HubSpot to Power BI that the integration provides:
HubSpot Data Data Flow Power BI
| Companies | --> | Companies |
| Contacts | --> | Contacts |
| Deals | --> | Deals |
| Engagements | --> | Engagements |
| Email Events | --> | Email Events |
| Tickets | --> | Tickets |
| Owners | --> | Owners |
| Products | --> | Products |
| Forms | --> | Forms |
| Companies | --> | Company Properties |
| Contacts | --> | Contact Properties |
| Associations | --> | CRM Associations |
| Deal Pipelines | --> | Deal Pipelines |
| Deals | --> | Deal Properties |
| CampaignEmailEvents | --> | Marketing Email |
| Custom Objects | --> | CRM Associations |
| Quotes | --> | CRM Associations |
| Contact Lists | --> | Contact Lists |
| Website Pages | --> | Analytics |
| Workflows | --> | Workflows |
Here is a link to the documentation: https://support.datawarehouse.io/hc/en-us/articles/360006051874-Power-Bi-Connector-Manual