Forum Discussion
HubSpot / Power BI integration
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.
5 Replies
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
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.
Hi Anonymous , 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
Hi Anonymous , 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
Hi, as a workaround, maybe you can use a 3rd party connector, it can save you a lot of time compared to other options. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Hubspot connector in the data sources list:
After that, just grant access to your Hubspot account using your credentials, then on preview and destination page you will see a preview of your Hubspot fields:
There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.
