How to Connect HubSpot to Power BI

Connecting HubSpot to Power BI lets you combine marketing and sales activity with revenue, finance and operations in one governed view. As with most SaaS platforms there is no native Microsoft connector, so the practical routes are the HubSpot API, a third-party connector, or a warehouse-backed pipeline you own. The right choice depends on which HubSpot hubs you use, how much history you need, and whether you intend to rebuild attribution or simply report what HubSpot already calculates.

Options for connecting HubSpot

HubSpot API. HubSpot exposes well-documented REST APIs (CRM objects, marketing, analytics and events) secured with OAuth or private app tokens. You can call them from Power Query, a Fabric or Azure Data Factory pipeline, or a small extraction script. This gives full control over the model; you own pagination, rate limits and token management.

Third-party connector. Several vendors publish HubSpot connectors that handle authentication and incremental loads, which is the quickest route to a working dashboard, at the cost of a subscription and a vendor dependency.

Warehouse-backed pipeline. Landing HubSpot data in a database via Data Integration and Warehousing is the pattern for long history, large volumes, and blending marketing and sales with revenue data: the foundation for proper closed-loop reporting.

Marketing and sales KPIs

The value is in joining the whole funnel in one place. Useful HubSpot KPIs include marketing-qualified and sales-qualified leads, lead-to-customer conversion rate, cost per lead, campaign performance, email engagement, deal pipeline by stage, win rate, sales cycle length, and customer acquisition cost when blended with finance data. The standout move is closed-loop reporting: tie marketing source through to closed-won revenue, which usually means joining HubSpot deals with finance data such as Xero or QuickBooks in the same model.

Attribution caveats

Attribution is where HubSpot dashboards most often mislead. HubSpot calculates attribution using its own model and tracking, and that logic does not travel with the raw data. If you extract contacts, deals and events and then try to recompute attribution in Power BI, you will likely get different numbers from HubSpot's own reports. Two safer approaches:

• Carry the attributed values across. Pull HubSpot's already-attributed figures rather than recalculating, and label them as HubSpot's model.
• Rebuild deliberately. If you must recompute, agree the attribution model explicitly (first touch, last touch, multi-touch) and document it, accepting it is a distinct model from HubSpot's.

Either way, never present attribution as exact. It is directional, and stakeholders should understand which model produced the number.

Limits and refresh

• API rate limits. HubSpot limits requests per app and per account by tier; large extracts refreshed too often can hit throttling, so prefer incremental loads.
• Subscription tiers. Some objects and analytics are only available on higher HubSpot tiers; confirm what your plan exposes.
• Custom properties. Internal property names differ from labels; document the mapping so the model stays readable.
• History. HubSpot retains activity but not a daily snapshot of every property; capture snapshots into a warehouse if you need to trend pipeline or lifecycle stage over time.
• Refresh cadence. A Pro workspace allows up to eight refreshes a day and Premium or Fabric up to 48; align with HubSpot's limits rather than maxing it out.

Choosing the right route

If you use one HubSpot hub and want a dashboard quickly, a third-party connector is sensible. For closed-loop reporting, multi-year history, or marketing and sales joined to revenue, invest in a warehouse-backed pipeline. As a rough UK guide, a scoped dashboard build starts from £6,000 with typical projects at £8,000–£14,000, and senior Power BI day rates run roughly £400–£850/day (as of 2026, confirm current pricing). Decide your attribution approach before building, because mismatched numbers erode trust fast.

A Trusted Numbers Review reviews your HubSpot setup, agrees the marketing and sales KPI definitions including attribution, and recommends the right connection method. Book one to turn HubSpot data into decisions you can trust.