Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
SRK_23
Helper I
Helper I

Hubspot as a source in PowerBI desktop

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

Thanks,

 

1 ACCEPTED SOLUTION
v-cherch-msft
Employee
Employee

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
BayardBradford
Frequent Visitor

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
Helper III
Helper III

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
Employee
Employee

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi there, @v-cherch-msft 

 

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

image.png

 

Is the driver still active?

 

Thanks for your help in advance!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.