Forum Discussion
Connecting HubSpot to Power BI
A Certified HubSpot App for connecting HubSpot to Power BI is available on the HubSpot App Marketplace. This Power BI integration uses a middleware solution that pulls HubSpot CRM data using prebuilt connectors to the HubSpot APIs. HubSpot data is hosted in secure Azure data warehouse, and is refreshed on a regularly scheduled basis. A free trial is available.
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
1 Reply
Skyvia offers two approaches for integrating Hubspot with Power BI. You can either sync Hubspot data into a data warehouse connected to Power BI or set up Hubspot data as an OData feed for direct Power BI access. Both options ensure efficient data transfer and analysis capabilities.
