HubSpot's own reporting covers most of what a sales or marketing team needs: pipeline by stage and owner, deal velocity and funnel reports, rep activity, marketing attribution, email performance, service ticket metrics, all on dashboards you can build from a large report library. It runs out in three places: when you hit the number of dashboards and reports your plan allows (they're capped by tier), when the people who need the numbers don't log into HubSpot, and when the question needs the accounts system too (revenue invoiced, margin, cash collected). There's no native Microsoft connector for HubSpot in Power BI, so connecting it means a third-party connector, an ETL service, or Power Query against the HubSpot API. All three work; they differ in cost, maintenance and who owns the result.
What does HubSpot's own reporting do well?
Honest list, because for a single-team HubSpot user this is usually enough:
- Sales dashboards. Pipeline by stage, forecast by close date, deals created and closed, rep leaderboards, activity (calls, emails, meetings). All standard.
- Funnel and velocity. Deal stage funnel, time in stage, conversion between stages. Better than most CRMs at this out of the box.
- Marketing reporting. Traffic, sources, campaigns, attribution (multi-touch on the higher tiers), email and landing page performance. This is where HubSpot is strongest and where nothing I build competes.
- Service Hub. Ticket volumes, time to first response, time to close, CSAT, by owner and pipeline.
- Custom report builder. Cross-object reports (contacts × deals × companies) on the Professional and Enterprise tiers.
- Dashboards. Configurable, shareable inside HubSpot, emailable on a schedule.
The caps: the number of dashboards and the number of reports per dashboard are limited by tier, with paid add-ons for more. The exact numbers have changed more than once and the published figures I found on 21 September 2026 disagreed with each other, so check the product limits page for your plan rather than trusting a blog.
Where does HubSpot reporting stop?
The caps. A growing team fills the dashboard allowance and either pays for more or starts deleting. That's a licensing decision, not a reporting one, but it's the first place people look elsewhere.
The audience. A managing director who wants pipeline on a phone without a HubSpot seat. A finance team that wants won deals against invoices. A board that wants one page. HubSpot seats cost money and the people above mostly won't log in anyway.
The join. "Which marketing source produces customers who actually pay?" "What's the margin on deals rep X closes?" "How much of the pipeline we forecast in Q1 turned into invoiced revenue?" Every one of those needs Xero, Sage, QuickBooks or Business Central joined to HubSpot on one customer list, and HubSpot can't see the accounts.
History. HubSpot holds property history, but reporting on "what did the pipeline look like on the first of each month" needs snapshots stored somewhere, and the built-in reports show current state.
How do you connect HubSpot to Power BI?
There's no HubSpot entry in Power BI's Get Data list. Three routes:
| Route | How it works | Cost shape | Refresh | Who maintains it |
|---|---|---|---|---|
| Marketplace connector | A Power BI custom connector or service from CData, Datawarehouse.io, Windsor.ai, Connectorly or similar; handles OAuth, paging, rate limits | Subscription, usually per connection or per user | Vendor schedule plus Power BI's (up to 8/day in a Pro workspace) | Vendor; you configure |
| ETL service | Coupler.io, Hevo, Supermetrics and similar copy HubSpot objects to a database, warehouse or files on a schedule; Power BI reads those | Subscription by rows or connectors | Your schedule | Vendor plus whoever owns the destination |
| Power Query against the API | M code calls HubSpot's API for contacts, companies, deals, tickets, with a private app token | Developer time; no subscription | Up to 8/day; token handling is yours | A developer; fragile without one |
Source: Microsoft's Power Query connector list and the vendors' pages, read 21 September 2026.
Which one:
- No developer, want it this month: marketplace connector. Accept the subscription as the price of not maintaining it.
- Already have a database or a warehouse, or want history kept: ETL service into it. The staged copy is where the month-end snapshots can live.
- Have a developer, want no subscription, low volumes: the API route. HubSpot's private app tokens make it simpler than it used to be, but name an owner.
For a First Report on HubSpot I'll usually use the API route with the token owned by the client, so nothing needs renewing afterwards.
What should you model once HubSpot is connected?
- Companies, contacts, deals, tickets as separate tables, joined on HubSpot's IDs. Don't flatten deals into contacts; a deal with three contacts becomes three deals.
- Deal stage and close-date history, from the property history endpoint, if you want slippage and stage age (see Sales Pipeline Report). It's the difference between a forecast and a hope.
- A customer key that the accounts system also holds. Company registration number, account number, or a HubSpot company property that stores the accounts ID. This is the whole join and if it's not populated, populating it is the first job.
- Pipeline and stage tables so the probabilities are in one place and can be set from measured win rate rather than from HubSpot's default percentages.
- A calendar and a set of measures (weighted pipeline, coverage, velocity, slippage) so every visual agrees.
- Snapshots if you want "pipeline on the first of each month": a scheduled copy of open deals to a table the model reads.
What does it cost?
Licences: Power BI Pro is £10.80 per user per month on Microsoft's UK page as of September 2026, paid yearly, excluding VAT, for everyone who opens the report. Plus a connector or ETL subscription if you take those routes. HubSpot seat prices are HubSpot's.
Build: a single-source report on HubSpot (pipeline, forecast, stuck deals, on a phone, for people without a HubSpot seat) is what the First Report is for. One system, one report answering one written question, the headline number reconciled back to HubSpot to the penny, published to your own workspace, £1,950 fixed, ten working days. HubSpot is one of the named systems at the First Report. HubSpot plus your accounts is two sources and a Reporting Sprint.
Common questions
Does Power BI have a native HubSpot connector?
No. As of September 2026 there's no HubSpot entry in Power BI's Get Data list. You connect through a marketplace connector (CData, Datawarehouse.io, Windsor.ai, Connectorly and others), an ETL service (Coupler.io, Hevo, Supermetrics) or Power Query calling the HubSpot API with a private app token.
Can I connect HubSpot to Power BI for free?
Only via the API route, which costs developer time rather than a subscription. Some ETL services have free tiers with row limits that suit a small CRM. Power BI Pro licences are still needed for anyone who views the report in a Pro workspace.
How many dashboards does HubSpot allow?
It depends on your tier and it has changed over time; the figures published by third parties on 21 September 2026 disagreed with each other. Check HubSpot's product limits page for your plan. Add-on packs for extra dashboards exist.
Can HubSpot report on revenue and margin?
Not from invoices. HubSpot reports on deal amounts, which are what reps entered. Invoiced revenue, cost of sales and cash collected live in the accounts system, so revenue and margin by customer or source need HubSpot joined to Xero, Sage, QuickBooks or Business Central.
Does HubSpot keep pipeline history?
It keeps property history on records (stage changes, close-date changes), which is enough for slippage and stage age. It doesn't keep a snapshot of the whole pipeline at each month end; for that, store snapshots in a model.
Should we upgrade our HubSpot tier for better reporting instead?
If the gap is HubSpot-only questions (attribution, cross-object reports, more dashboards), yes, look at the tier first; it's simpler than a build. If the gap is the audience or the accounts join, no tier closes it.
Will the Power BI numbers match HubSpot?
They have to. Every model I build has a reconciliation page with the model's open pipeline next to HubSpot's, and on the First Report the second half of the fee is only invoiced once that reconciliation ties.