All HubSpot versions
Works on Starter, Professional, and Enterprise.
Connecteur HubSpot Power BI
Connect HubSpot to Power BI and sync 100+ data tables automatically — contacts, deals, campaigns, tickets, custom objects, and more. Point-and-click setup.
CONNECT TO POWER BI
What is the HubSpot Power BI Connector?
The HubSpot Power BI Connector automatically syncs your HubSpot data into into to Microsoft Power BI with three clicks. Build dynamic dashboards and reports with HubSpot data with ease.
Our service automatically provisions you with a 4 Vcore Azure SQL database, creates all the tables and schemas, then keeps them in sync on your chosen schedule. Connect HubSpot to Power BI in minutes — no ETL engineers or custom code required.
Works on Starter, Professional, and Enterprise.
Get started immediately with our free pre-built Power BI dashboard template.
Access all 100+ tables and unlimited records for one flat fee. No more pay per record pricing.
Our pipeline processes over 2 billion HubSpot records daily across thousands of customers.
Data coverage
Every Power BI Connector subscription includes the complete HubSpot data model — contacts, deals, marketing campaigns, service tickets, commerce, web analytics, custom objects, and more. All tables include your custom HubSpot properties.
All tables include custom properties. Read the full table definitions here.
How it works
No ETL engineers. No coding. Point-and-click setup that takes under 5 minutes.
Authenticate your HubSpot portal via OAuth. Super Admin access required. Takes under two minutes.
Start your trial and receive your Power BI Connector credentials. Then add our app as a Data Source in Power BI following the instructions here.
We automatically import all tables and relationships in your Power BI workspace, then sync your data to those tables on your chosen schedule.
Free Resource
Get a head start with our free Power BI template. Pre-built reports and dashboards ready to connect to your HubSpot data out of the box.
Your HubSpot data should be in your BI Tool — not stuck in platform. Start your free trial today.
Frequently asked questions
Everything you need to know before getting started.
A 4 Vcore SQL Database powered connector that automatically syncs your HubSpot CRM data into Microsoft Power BI. 100+ tables, unlimited records, fixed price.
Datawarehouse.io syncs your HubSpot data into a dedicated Azure SQL database. You then connect Power BI to that database using the built-in Azure SQL Database connector, select your tables, and build reports. Supports Power BI Desktop, PowerbI Online, PowerBI Gateway, Microsoft Fabric.
Your sync frequency depends on your plan: Lite syncs every 24 hours, Standard every 6 hours, Advanced every hour, and Max every 15 minutes. Standard, Advanced, and Max users can also set their preferred sync time.
Yes. Datawarehouse.io apps support more than just HubSpot as a data source. Additional sources such as Google Ads and LinkedIn Ads are available and included in your subscription.
Yes. All Datawarehouse.io apps allow you to add other users to your account or database. Users can be added in seconds through our self service user interface.
Yes. SOC 2 certified and GDPR compliant. All data is encrypted in transit and at rest. Only you have read-only access to your Azure SQL database. Data is processed in Azure EU West or North America depending on your billing region.
Yes. Users on the Standard (6-hour), Advanced (1-hour), and Max (15-minute) plans can set their preferred sync time from the user panel.
Yes. Our apps have been independently reviewed by HubSpot and have met their standards for security and technical quality.
Yes. A 14-day free trial is available. A free Power BI dashboard template is also included to help you get started quickly.
Sécurité
Independently audited security controls covering availability, confidentiality, and processing integrity.
All data encrypted in transit and at rest. Only you have read-only access to your Azure SQL database. HubSpot authentication uses OAuth 2.0.
Data processed in Microsoft Azure EU West or North America depending on your billing region.
Independently reviewed by HubSpot for security and technical quality standards.
Join 10,000+ teams who’ve eliminated manual exports.
Connect HubSpot to Power BI and start your free trial —
Works with Power BI Desktop, PowerBI Online, PowerBI Gateway & More
