Power BI + HubSpot
Connect Power BI and HubSpot for Real-Time Sales & Marketing Intelligence
Stream your HubSpot CRM data directly into Power BI dashboards for real-time reporting, clearer pipeline visibility, and smarter revenue decisions.
Why integrate Power BI and HubSpot?
Power BI and HubSpot are two of the most useful tools in a modern revenue team's stack, but when they operate in silos, business intelligence stays locked behind manual exports and stale spreadsheets. Connecting HubSpot's CRM data with Power BI's analytics and visualization engine lets teams build live dashboards that reflect the actual state of their pipeline, campaigns, and customer lifecycle. tray.ai makes this connection work automatically, moving contacts, deals, activities, and marketing metrics from HubSpot into Power BI without any custom code.
Automate & integrate Power BI & HubSpot
Use case
Live Sales Pipeline Reporting
Automatically push HubSpot deal data — stage, owner, close date, and deal value — into a Power BI dataset so sales managers can monitor pipeline health in real time. Any time a deal is created, updated, or closed in HubSpot, the change shows up immediately in your Power BI dashboards. No more Monday morning scramble to pull pipeline reports manually, and no more forecasts that are already out of date by Tuesday.
Use case
Marketing Campaign Performance Analytics
Sync HubSpot marketing email metrics, landing page conversions, and campaign attribution data into Power BI to build comprehensive campaign performance dashboards. Blend HubSpot engagement data with ad spend from other platforms to calculate true ROI and cost-per-acquisition across every marketing channel. Marketing teams get a consolidated view that goes well beyond what HubSpot's native campaign reporting can show.
Use case
Contact Lifecycle and Funnel Analysis
Stream HubSpot contact lifecycle stage changes into Power BI to build detailed funnel reports showing conversion rates at every step from lead to customer. Track how long contacts spend in each lifecycle stage, identify where leads are dropping off, and measure how sales and marketing activities affect progression velocity. Revenue operations teams can use this data to pinpoint bottlenecks and improve the buyer journey.
Use case
Sales Rep Performance Dashboards
Pull HubSpot activity data — calls logged, emails sent, meetings booked, and deals closed — into Power BI to create individual and team-level performance scorecards. Sales leaders can track activity ratios, quota attainment, and win rates for each rep without manually compiling data from HubSpot reports. Automated daily refreshes mean managers have current performance data before standups and 1:1s.
Use case
Customer Churn and Retention Intelligence
Combine HubSpot deal close data, contact engagement scores, and lifecycle history in Power BI to build predictive churn and retention models. Visualizing patterns in customer behavior leading up to churn events lets customer success teams spot at-risk accounts earlier and take action before it's too late. This integration gets even more useful when HubSpot data is blended with product usage or support ticket data in the same Power BI model.
Use case
Revenue Attribution and Multi-Touch Reporting
Integrate HubSpot's deal and campaign attribution data into Power BI to build custom multi-touch attribution models that go beyond HubSpot's built-in last-touch or first-touch reporting. Marketing and revenue operations teams can assign weighted credit across every touchpoint in the buyer journey and see which channels, campaigns, and content pieces are actually driving closed revenue. Leadership gets the confidence to make smarter budget allocation decisions.
Use case
Executive Revenue and Go-To-Market Dashboards
Automate board-ready revenue dashboards by continuously syncing HubSpot pipeline, bookings, and marketing performance data into Power BI executive reports. Finance, sales, and marketing leaders can access a shared dashboard showing bookings vs. target, pipeline coverage ratio, and marketing-sourced revenue contribution — all refreshed automatically. This replaces the hours spent compiling weekly business review decks with live, always-accurate visual reports.
Get started with Power BI & HubSpot integration today
Power BI & HubSpot Challenges
What challenges are there when working with Power BI & HubSpot and how will using Tray.ai help?
Challenge
HubSpot API Rate Limits Causing Incomplete Data Syncs
HubSpot enforces API rate limits that can cause large bulk syncs — especially for historical contact or deal data — to fail or return incomplete results, leaving Power BI dashboards with gaps in their underlying datasets.
How Tray.ai Can Help:
tray.ai handles API rate limit management automatically, using built-in throttling, retry logic, and pagination to make sure every record transfers completely and reliably, even for large HubSpot portals with hundreds of thousands of contacts or deals.
Challenge
Keeping Power BI Datasets Fresh Without Triggering Full Refreshes
Power BI's standard dataset refresh model requires refreshing the entire dataset to update any records. That's slow and resource-intensive when only a small number of HubSpot records have changed since the last sync.
How Tray.ai Can Help:
tray.ai supports incremental, event-driven data pushes using Power BI's Push Rows API, so only new or changed HubSpot records are written to the dataset in real time — keeping dashboards current without the overhead of full dataset refreshes.
Challenge
Mapping Mismatched Data Schemas Between HubSpot and Power BI
HubSpot stores data in its own property schema with custom field names, association objects, and enumeration values that rarely map cleanly to the column names and data types a Power BI dataset expects. The result is transformation errors and broken reports.
How Tray.ai Can Help:
tray.ai's visual data mapper and JSONPath transformation tools let teams define precise field mappings, type conversions, and value translations between HubSpot's API response structure and their Power BI dataset schema — without writing ETL code.
Challenge
Handling HubSpot Association Data Across Contacts, Companies, and Deals
HubSpot's data model relies heavily on associations between objects — a deal may be linked to multiple contacts and a company — but flattening these relationships into a tabular Power BI dataset requires multiple API calls and careful data modeling.
How Tray.ai Can Help:
tray.ai workflows can chain multiple HubSpot API calls within a single automation, fetching associated object data and assembling a complete, denormalized record before writing to Power BI — so your dashboards have all the relational context they need for accurate reporting.
Challenge
Ensuring Data Consistency When HubSpot Records Are Updated or Deleted
When deals are merged, contacts are deleted, or deal stages are rolled back in HubSpot, those changes need to be reflected in Power BI. If they're not, historical dashboards will show inflated pipelines, duplicate records, and inaccurate revenue figures.
How Tray.ai Can Help:
tray.ai listens for HubSpot webhook events covering record updates, merges, and deletions, then runs the appropriate upsert or delete operation in the Power BI dataset — maintaining referential integrity across both systems automatically.
Start using our pre-built Power BI & HubSpot templates today
Start from scratch or use one of our pre-built Power BI & HubSpot templates to quickly solve your most common use cases.
Power BI & HubSpot Templates
Find pre-built Power BI & HubSpot solutions for common use cases
Template
Sync New HubSpot Deals to Power BI Dataset in Real Time
Automatically pushes newly created HubSpot deals into a Power BI streaming dataset or updates a scheduled dataset table so pipeline reports always reflect the latest opportunities without any manual exports.
Steps:
- Trigger fires when a new deal is created in HubSpot
- Fetch full deal properties including owner, stage, amount, and close date from HubSpot API
- Format and map deal fields to the corresponding Power BI dataset schema
- Push the deal record to the target Power BI dataset via the Push Rows API
- Log the sync event and alert the team if any records fail to transfer
Connectors Used: HubSpot, Power BI
Template
Daily HubSpot Contact Export to Power BI for Funnel Analysis
Runs on a schedule to extract all HubSpot contacts updated in the last 24 hours, transforms the lifecycle stage and engagement data, and loads it into a Power BI dataset powering funnel and segmentation dashboards.
Steps:
- Scheduled trigger fires once daily at a configured time
- Query HubSpot Contacts API for all records updated in the past 24 hours
- Extract lifecycle stage, lead source, engagement score, and associated deal data
- Transform and deduplicate records to match Power BI dataset structure
- Upsert contact records into the Power BI dataset for funnel reporting
Connectors Used: HubSpot, Power BI
Template
HubSpot Deal Stage Change to Power BI Pipeline Update
Listens for deal stage changes in HubSpot and immediately updates the corresponding record in a Power BI dataset so pipeline stage distribution reports and weighted forecasts reflect every move a deal makes through the sales process.
Steps:
- Trigger activates on any HubSpot deal stage change event via webhook
- Retrieve updated deal details from HubSpot including new stage, probability, and close date
- Determine if the deal already exists in the Power BI dataset
- Update the existing row or insert a new record with the latest stage information
- Refresh the Power BI dataset to surface changes on connected dashboards
Connectors Used: HubSpot, Power BI
Template
HubSpot Marketing Email Metrics to Power BI Campaign Dashboard
Periodically pulls HubSpot marketing email send, open, click, and unsubscribe metrics and loads them into Power BI to power campaign performance dashboards, so marketers can analyze engagement trends over time.
Steps:
- Scheduled trigger fires weekly or on-demand after major campaign sends
- Call HubSpot Email Marketing API to retrieve metrics for all emails sent in the period
- Flatten and normalize send, open, click-through, and bounce data by campaign
- Load the campaign metrics into the designated Power BI dataset table
- Trigger a Power BI dataset refresh so dashboards display updated engagement data
Connectors Used: HubSpot, Power BI
Template
Sync HubSpot Company Records to Power BI for Account-Level Analytics
Keeps a Power BI dataset populated with the latest HubSpot company data — including industry, revenue tier, associated contacts, and deal totals — so account-based revenue reports and territory dashboards stay accurate.
Steps:
- Trigger fires when a HubSpot company record is created or updated
- Fetch company properties and associated deal and contact counts from HubSpot
- Map company attributes to the Power BI dataset schema for account reporting
- Upsert the company record in the Power BI dataset
- Flag any high-value accounts for priority review in the Power BI dashboard
Connectors Used: HubSpot, Power BI
Template
HubSpot Won Deals to Power BI Revenue Recognition Report
Automatically captures every HubSpot deal marked as Closed Won and writes the deal details to a Power BI dataset used for revenue recognition, quota tracking, and bookings vs. target reporting.
Steps:
- Trigger fires when a HubSpot deal is moved to the Closed Won stage
- Retrieve deal amount, close date, owner, associated company, and product line from HubSpot
- Map closed deal fields to the revenue recognition schema in Power BI
- Append the won deal as a new row in the Power BI bookings dataset
- Send an automated Slack or email notification to leadership with the deal summary
Connectors Used: HubSpot, Power BI