Connect Hubspot to Power BI: Dashboards in Minutes

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

sso google logo
Sign up with Google
sso facebook logo
Sign up with Facebook
sso microsoft logo
Sign up with Microsoft
sso linkedin logo
Sign up with Linkedin

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Hubspot
Power BI

Visualize Hubspot Data in Power BI

Connect your Hubspot account to Kondado in minutes without writing any code or dealing with complex technical setup. Simply authenticate your account and choose exactly which data pipelines you want to replicate, from Contacts and Deals to Email Events and Tickets. Your marketing, sales, and service information flows directly into Power BI where you can build interactive dashboards that help your team track campaign performance and make faster decisions.

Kondado provides a direct integration between Hubspot and Power BI, replicating your CRM and marketing automation data on a configurable schedule ranging from every 5 minutes to daily. Access 24 available pipelines covering 805 fields including Companies, Deals, and Engagements to create comprehensive reports that keep every department aligned with current business metrics.

Business users can easily combine Hubspot information with other sources to analyze the complete customer journey, from first website visit through closed deals and ongoing support. The intuitive interface lets marketing teams monitor lead generation, sales managers track pipeline health, and operations leaders measure customer satisfaction, all within familiar Power BI reports that update automatically.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

With your Hubspot data available in Power BI, you can analyze the complete customer lifecycle by combining information from the Contacts, Deals, and Email Events pipelines. Marketing teams track which campaigns generate qualified leads by connecting form submissions to eventual deal closures, while sales managers monitor pipeline velocity and conversion rates across different stages. Customer success teams use Tickets and Engagements data to identify support trends and measure response times. This creates a single source of truth that aligns marketing, sales, and service operations around shared revenue goals and helps leadership understand the true cost of acquisition across every touchpoint.

Try out all the features for free for 14 days

Hubspot data available in Power BI

24
available pipelines
805
extractable fields

Available integrations

Integration Description
Companies Includes information such as id, name, and properties related to contacts and deals.
Contact lists Presents contact lists with details on membership and relevant properties.
Contacts Brings contact information such as id, email, name, and created date.
Contacts: form submissions Includes form submissions with fields such as conversion id, content type, and form id.
Contacts: lists membership Displays the association of contacts to specific lists and their properties.
Custom object Represents custom objects with fields such as id and specific properties.
Deals Contains information about deals, including id, value, and related contacts.
Email events Records email events with details on sending, opens, and clicks.
Engagements: Calls Includes call details such as id, dispositions, and related objects.
Engagements: Emails Presents email details including id and related objects.
Engagements: Meetings This table contains information about meetings, including fields such as id, contact_id, company_id, and updated_at.
Engagements: Notes Notes table includes fields such as id, contact_id, body, and created_at, allowing tracking of relevant information.
Engagements: Tasks Tasks table presents fields such as id, contact_id, due_date, and status, facilitating activity management.
Feedback Submissions Feedback submissions table includes fields such as id, contact_id, feedback_type, and created_at, allowing analysis of responses.
Leads Leads table contains information such as id, email, status, and created_at, essential for managing potential customers.
Line Items Line items table presents fields such as id, deal_id, product_id, and quantity, useful for tracking sales.
Marketing Emails Marketing emails table includes fields such as id, subject, sent_date, and open_rate, allowing analysis of campaigns.
Owners Owners table contains fields such as id, name, email, and created_at, essential for user management.
Payments Payments table includes fields such as id, amount, payment_date, and status, useful for financial control.
Pipelines Pipelines table presents fields such as id, name, stage, and created_at, important for sales management.
Products Table contains information about products, including fields such as id, name, price, and description.
Properties Metadata Table presents metadata of properties, including fields such as name, type, and description.
Property History Table logs changes to properties, with fields such as id, created_at, and previous_value.
Tickets Table includes information about tickets, with fields such as id, status, priority, and created_at.
Companies
Includes information such as id, name, and properties related to contacts and deals.
Contact lists
Presents contact lists with details on membership and relevant properties.
Contacts
Brings contact information such as id, email, name, and created date.
Contacts: form submissions
Includes form submissions with fields such as conversion id, content type, and form id.
Contacts: lists membership
Displays the association of contacts to specific lists and their properties.
Custom object
Represents custom objects with fields such as id and specific properties.
Deals
Contains information about deals, including id, value, and related contacts.
Email events
Records email events with details on sending, opens, and clicks.
Engagements: Calls
Includes call details such as id, dispositions, and related objects.
Engagements: Emails
Presents email details including id and related objects.
Engagements: Meetings
This table contains information about meetings, including fields such as id, contact_id, company_id, and updated_at.
Engagements: Notes
Notes table includes fields such as id, contact_id, body, and created_at, allowing tracking of relevant information.
Engagements: Tasks
Tasks table presents fields such as id, contact_id, due_date, and status, facilitating activity management.
Feedback Submissions
Feedback submissions table includes fields such as id, contact_id, feedback_type, and created_at, allowing analysis of responses.
Leads
Leads table contains information such as id, email, status, and created_at, essential for managing potential customers.
Line Items
Line items table presents fields such as id, deal_id, product_id, and quantity, useful for tracking sales.
Marketing Emails
Marketing emails table includes fields such as id, subject, sent_date, and open_rate, allowing analysis of campaigns.
Owners
Owners table contains fields such as id, name, email, and created_at, essential for user management.
Payments
Payments table includes fields such as id, amount, payment_date, and status, useful for financial control.
Pipelines
Pipelines table presents fields such as id, name, stage, and created_at, important for sales management.
Products
Table contains information about products, including fields such as id, name, price, and description.
Properties Metadata
Table presents metadata of properties, including fields such as name, type, and description.
Property History
Table logs changes to properties, with fields such as id, created_at, and previous_value.
Tickets
Table includes information about tickets, with fields such as id, status, priority, and created_at.

Try out all the features for free for 14 days

How to create Hubspot dashboards in Power BI

Visualize your data automatically — no spreadsheet exports or custom scripts.

1
Connect Your Hubspot Account

Add Hubspot as a data source by entering your credentials and selecting which pipelines to replicate, such as Contacts, Deals, or Tickets.

2
Send Data to Power BI

Choose Power BI as your destination to replicate data directly into your workspace without intermediate databases or complex configuration.

3
Configure Refresh and Visualize

Set your preferred update schedule from 5 minutes to daily, then build custom reports in Power BI combining marketing, sales, and service data for complete business insights.

Access Hubspot data in Power BI and combine it with dozens of other data sources

If the source you want is not listed, drop us a chat message. We love to add new sources!

Visualize Hubspot data in other BI tools

If the software you need is not listed, drop us a messagem. You can use almost every tool

Hundreds of data-driven companies trust Kondado
arezzo
brf
Contabilizei
dpz
Experian
grupo_soma
inpress
multilaser
olist
unimed
v4_company
yooper

Frequently Asked Questions (FAQ)

Answers about visualizing Hubspot data in Power BI automatically

How do I connect Hubspot to Power BI without technical knowledge?
Start by adding Hubspot as a data source in your Kondado account and authenticate with your existing Hubspot credentials. Select the specific pipelines you need, such as Contacts or Deals, then choose Power BI as your destination. The connection works through Kondado's direct integration, so you don't need to configure any databases or write code to start visualizing your data.
What marketing KPIs can I track with Hubspot data in Power BI?
Monitor email campaign performance using the Marketing Emails and Email Events pipelines to track open rates, click-through rates, and unsubscribes. Analyze lead generation effectiveness by connecting Contacts data with form submission information to see which channels deliver qualified prospects. You can also measure marketing qualified lead conversion times and cost per acquisition by combining this data with your Deals information.
How often does Hubspot data update in my Power BI dashboards?
You configure the refresh schedule based on your business needs, choosing from intervals as frequent as every 5 minutes or extending to hourly or daily updates. This automated refresh keeps your Power BI reports current without manual exports or data entry. Marketing teams often prefer 15-minute updates for campaign monitoring, while executive dashboards might refresh daily.
Can I share Hubspot dashboards with my team who don't have Hubspot licenses?
Yes, once your data is in Power BI, you can distribute reports to anyone with Power BI access regardless of their Hubspot permissions. This lets you share pipeline updates with stakeholders or campaign results with clients without purchasing additional Hubspot seats. Your team views the visualizations while Kondado handles the data replication behind the scenes.
What custom dashboards should I build for sales pipeline analysis?
Create a pipeline velocity dashboard using the Deals and Pipelines data to track how opportunities move between stages and identify bottlenecks. Build a win/loss analysis report combining Deals with Companies and Owners data to understand which sales reps close fastest and which company segments convert best. Add Engagements data to see how meeting and call activity correlates with closed revenue.
How do I combine Hubspot marketing data with sales data in Power BI?
Replicate both your Marketing Emails and Contacts pipelines alongside your Deals data to create attribution reports showing which campaigns generate revenue. Use the Contact Lists membership pipeline to segment your analysis by lead source or persona, then connect this to Deal values in Power BI. This unified view helps you calculate true marketing ROI by tracing dollars closed back to specific email campaigns or landing pages.
Can I analyze Hubspot support tickets alongside sales metrics?
Absolutely, replicate the Tickets pipeline along with your Deals and Companies data to create a complete customer health dashboard. You can identify which high-value customers submit frequent support requests or measure average resolution times by company tier. This connection helps account managers prioritize outreach and helps leadership understand the relationship between customer success efforts and renewal rates.

Try out all the features for free for 14 days