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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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

7 REPLIES 7
Aryna
Helper V
Helper V

Hi @SRK_23 , you can try Power Bi connectors. Here one of the providers: https://vidi-corp.com/

They also offer free Power BI templates

janunez
Frequent Visitor

Hi @SRK_23,

 

You can try our open source connector:

https://www.youtube.com/watch?v=oOmJJA8_kWg

 

janunez_0-1716308565308.png

Javier Núñez, CEO

Audox

CRM, BI, PM Consulting Services

www.audox.com

Brianyoung
New Member

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.

hubspot-powerbi.png

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
Microsoft Employee
Microsoft 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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