HubSpot / Power BI integration

[fionalindberg]

At work we use Power BI extensively, and have a HubSpot CRM. Within Power BI desktop and PowerPlatform Dataflows there are currently no connectors for HubSpot. The 3rd party options are expensive. My architect/software dev. husband is currently working on building a solution with the goal of having a robust but much cheaper solution available. We will probably donate to nonprofits for free, as we work for a nonprofit organization!

Anyway, what marketplaces would you recommend for advertising Power BI integration solutions? We're more on the technical-side and not as marketing savvy. However, we know there is a big need for this type of interface.

[Aryna]

Hi @fionalindberg , you can also try this provider of Power BI connectors: https://vidi-corp.com/ 

I found them very helpful as they also offer free Power BI templates. Here is an example of Hubspot reports in Power BI I recently developed: https://drive.google.com/file/d/1VnnFaNjECPMTqnjRs8_5h6j8MQsAV40h/view?usp=sharing

[Aryna]

Hi @fionalindberg , you can also try this provider of Power BI connectors: https://vidi-corp.com/ 

I found them very helpful as they also offer free Power BI templates. Here is an example of Hubspot reports in Power BI I recently developed: https://drive.google.com/file/d/1VnnFaNjECPMTqnjRs8_5h6j8MQsAV40h/view?usp=sharing

[BobMarf]

Skyvia offers two distinct approaches to integrate Power BI with HubSpot. The first method syncs HubSpot data to a connected data warehouse for use in Power BI. Alternatively, it allows for the creation of an OData feed directly from HubSpot data, enabling Power BI to access it directly. Both solutions are designed to streamline the process of data importation and enhance analytical capabilities.

[BayardBradford]

A HubSpot Certified App is available in the HubSpot App Marketplace for connecting HubSpot to Power BI.  There is a free trail. 

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