Connecting HubSpot to Power BI

[BayardBradford]

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

[claudejoshua]

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.