HubSpot connector · CRM & Marketing
HubSpot Power BI connector
The DigiData HubSpot connector synchronizes contacts, companies and deals through HubSpot's official CRM API and makes the data available through OData and CSV.
Here you will find the supported data, operation and availability of the connection. Follow the practical guide HubSpot Power BI setup guide for the steps in Power BI.
Last reviewed:
The reason
Why connect HubSpot to DigiData?
Connect a HubSpot portal with OAuth2 and synchronize contacts, companies and deals to DigiData. Contact fields include names, email, phone, company and job title. Company fields include name, domain, location and industry. Deals include amount, stage, pipeline and close date. DigiData exposes these source tables through OData for recurring reports and through CSV for separate exports.
Connecting HubSpot to Power BI in short
The HubSpot connector is available and synchronizes supported tables such as Deals, Contacts and Companies. DigiData offers these source records via OData for Power BI and Excel and via CSV for separate exports. The connector only supplies the entities listed on this page; source permissions, the source API, and your sync schedule determine which records and updates are available. You set up relationships, calculations and dashboards in the reporting tool.
Conditions
Availability, setup and conditions
- Availability
- Status: Available. The connector provides the entities listed on this page under "Available data".
- Setup
- Add HubSpot in the DigiData dashboard and configure access to the source. DigiData confirms during setup which accounts and entities are available.
- Refresh
- Automatic synchronization based on the integration schedule. New source data will not appear until the source sync and then the Power BI refresh are complete.
- Security
- API keys and tokens for linked applications are stored encrypted.
- Limitations
- Only the listed entities are supported. Availability and timeliness depend in part on the source API and your rights in HubSpot. DigiData supplies source data via OData and CSV; you set up relationships, measures and dashboards in the reporting tool.
- Price and trial period
- €50 per month for the HubSpot connector, plus a €95 monthly DigiData platform fee, without start-up costs. You can test DigiData 14 days for free. View current prices.
What you get
What do you get with the HubSpot link?
An overview of what DigiData does with your HubSpot data:
Which data
Available HubSpot data in DigiData
The following entities are automatically synchronized and available via OData or CSV export:
Use cases
What can you do with HubSpot data?
Pipeline value and deal-stage reporting
Contact and company reporting in Power BI or Excel
Monitoring open deals and expected close dates
Combining HubSpot tables with other DigiData sources in a reporting model
How it works
How does the HubSpot link work?
Connect HubSpot
Link your HubSpot account via the DigiData dashboard. Safe and fast.
Select your dates
Check which accounts, environments, and entities are available for this resource. The options differ per connector.
Analyze in Power BI
Use the OData feed in Power BI, Excel or download CSV exports.
HubSpot in Power BI
Load HubSpot contacts, companies and deals into Power BI through the DigiData OData feed. Build pipeline, company and contact reports using the synchronized fields; relationships and measures are configured in your Power BI model.
Frequently asked questions
Questions about the HubSpot integration
How do I connect HubSpot to Power BI?
With DigiData you automatically synchronize HubSpot data to an OData feed. In Power BI Desktop, choose 'Get Data', select OData feed and paste the DigiData URL. You can then load, combine and refresh the tables without building a HubSpot API connection yourself.
How often is HubSpot data refreshed?
DigiData synchronizes HubSpot according to your integration schedule. The exact frequency and availability of new records depend on your settings and the source API.
What does the HubSpot connection cost?
DigiData charges platform costs plus an amount per active integration. There are no start-up costs and you can test for 14 days for free. View the current price on the prices page.
Which HubSpot data does DigiData synchronize?
The current connector synchronizes contacts, companies and deals. Marketing campaigns, tickets, engagements and custom objects are not included.
Can I connect HubSpot with my accounting software?
You can load HubSpot and accounting tables from supported connectors into the same reporting environment. You configure the relationships and calculations in your reporting model.
Combine
Other integrations that may interest you
Most companies do not run on one package. Place HubSpot next to your other sources, so that you have one report.
14 days free · no start-up costs
Ready to connect HubSpot to DigiData?
Use the trial period to validate the available tables, synchronization and your reporting model with your own data.
