Easy Tech TutsHow to Connect HubSpot With Microsoft Power BI (Sales Data Setup) Easily 2026
By Impran M NLast checked against official docs
Manually exporting HubSpot data into spreadsheets doesn't scale once a sales team grows, and connecting it to Power BI closes that gap. Power BI has no dedicated, built-in HubSpot connector the way it does for Dynamics or Salesforce, and HubSpot doesn't publish its own OData feed either, so the common route runs through a third-party bridge sitting between the two.
This guide covers what that bridge actually does, how the Power BI side of the setup works, and what a finished pipeline report can look like once deal data is flowing in. It's aimed at sales teams and marketers who want live reporting instead of static exports.
01Know your three real options before you start
Power BI's Get Data catalog has no HubSpot logo to click, which is the detail that trips people up first. Three routes get HubSpot data in anyway: a paid third-party bridge that generates an OData feed for Power BI to connect to (CData and Skyvia both offer this), a ready-made connector app listed in HubSpot's own App Marketplace, or a custom Power Query built against HubSpot's REST API with a private-app access token. This guide follows the OData bridge route, since it needs the least code.
02Set up a bridge in front of HubSpot
HubSpot does not expose its own OData endpoint, so before opening Power BI you need a middleware service, such as CData Connect Cloud or Skyvia, connected to your HubSpot account through a private app or OAuth token. That service generates the feed URL Power BI will connect to; there is no equivalent URL sitting inside HubSpot's own settings. Confirm the objects you need (deals, contacts, pipeline stages) are exposed through the bridge, since not every service surfaces every HubSpot object by default.
03Open Get Data and choose the OData feed connector
In Power BI Desktop, click Get Data to open the source catalog, organized into categories including File, Database, Power Platform, and Online Services. Choose the OData feed connector, listed under Online Services, rather than searching further for a HubSpot-branded option that isn't there.
04Connect and pull in deal and pipeline objects
Selecting OData feed opens a dialog with Basic and Advanced modes and a single URL field. Paste the feed URL your bridge service generated, not a HubSpot address; the field itself accepts any valid OData address.
Once it connects, Power BI's Navigator lists the tables the bridge exposed, typically deals, contacts, and pipeline stage objects for a sales setup. Select only the tables you'll report on, since an over-broad import slows both the initial load and every refresh after it.
05Build and tighten the pipeline report
With sales data loaded, a bar or pie visual broken out by a date or stage field is the fastest way to see where deals sit. The example here shows deal amounts broken out by date, colored by segment, the kind of at-a-glance view sales leaders check daily.
Swap the legend field to pipeline stage instead of date to see where deals are stuck rather than when they closed. Group pipeline value, rep performance and deal counts onto one page instead of spreading them across tabs, add slicers for date range and sales rep, then set a scheduled refresh once the report is published. A scheduled refresh against a third-party bridge depends on that service staying connected within its own limits, not only on Power BI's refresh settings.
When it doesn't work
The OData feed dialog won't connect to anything
Why: HubSpot doesn't expose its own OData endpoint, so a HubSpot URL pasted directly into the feed field has nothing to connect to. The URL has to come from a bridge service such as CData Connect Cloud or Skyvia.
Fix: Set up the bridge first, generate its OData feed URL there, then paste that URL into Power BI's feed dialog.
Refresh works in Desktop but fails once the report is published to the Power BI service
Why: A cloud bridge needs its own live connection and cached credentials in the service. Desktop can succeed locally while the scheduled service refresh fails if the bridge's session or gateway has expired.
Fix: Check the bridge service's own connection status and re-authenticate it, then reconfigure the scheduled refresh in the Power BI service.
The initial load or every refresh after it takes a long time
Why: HubSpot accounts can expose a large number of objects, and selecting all of them in Navigator pulls in far more than a sales report needs.
Fix: In Navigator, select only the specific tables you're reporting on, such as deals, contacts, and pipeline stages, instead of the full list.
Frequently asked questions
Does Power BI have a dedicated HubSpot connector?
No. There's no HubSpot-branded connector in Power BI's Get Data catalog.
Where does the OData feed URL come from?
Not from HubSpot. HubSpot doesn't publish its own OData endpoint, so the URL has to come from a bridge service, such as CData Connect Cloud or Skyvia, connected to your HubSpot account.
Is there a simpler, HubSpot-listed option?
HubSpot's own App Marketplace lists a third-party Power BI Integration app, built by Datawarehouse.io, that handles the connection for a monthly fee instead of requiring you to set up a bridge yourself.
Does this cost anything beyond my HubSpot and Power BI plans?
Usually yes. Bridges and marketplace connector apps charge separately; Datawarehouse.io's listing starts at $79 a month.
Can I skip third-party tools entirely?
Yes, by writing a custom Power Query against HubSpot's REST API with a private app access token, though that takes development effort a ready-made bridge avoids.
Sources and last check
Click path and screens come from a recorded walkthrough. Re-checked in September 2026: Power BI still has no native HubSpot connector, and research turned up a fact the original draft got wrong. HubSpot does not publish its own OData feed, so the 'paste your account's feed endpoint' step needs a third-party bridge (CData, Skyvia) or a marketplace app such as Datawarehouse.io's Power BI Integration, confirmed as a real, paid, third-party listing in HubSpot's own App Marketplace.
About the author
Impran M N
I've been hooked on technology for as long as I can remember — especially the new tools and AI apps that seem to land every other week. Easy Tech Tuts is where I write up whatever I've just worked out: I do the task in the real product, record the screen, and turn it into the guide I wish I'd found first.
