Hubspot as a source in PowerBI desktop

[SRK_23]

Hi--  how to connect hubspot as a source in PowerBI desktop ?

Thanks,

[Brianyoung]

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.

[BayardBradford]

A HubSpot Certified App is available in the HubSpot App Marketplace for connecting HubSpot as a source in Power BI. 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

[adelheni]

Hello everyone, you can also use a web connector such as the one I'm using, it's been efficient for me, hope this would help.
https://windsor.ai/microsoft-power-bi-hubspot-report-dashboard-template/

[v-cherch-msft · Accepted solution]

Hi @SRK_23

You may vote for this idea about adding HubSpot data source in Power BI.

In addition, you can consider to create ODBC data source by after installing the HubSpot ODBC Driver, then connect to the ODBC data source in Power BI Desktop.

Regards,

Cherie

[jeroenwmwillems]

Hi there, @v-cherch-msft 

I tried to use the driver you mentioned, but received the following error:

Is the driver still active?

Thanks for your help in advance!