Introduction
If you want to bring HubSpot data into Power BI, the ZappySys ODBC API Driver makes it easy to connect, query, and refresh HubSpot objects directly inside Power BI—without Python scripts or manual exports.
Key Steps
- Create a HubSpot Private App and get your token
- Create an ODBC DSN using the ZappySys API Driver
- Select the HubSpot connector and test the connection
- Open Power BI → Get Data → ODBC and pick your DSN
- Load tables or write SQL queries for custom data retrieval
Example: Loading Data in Power BI
Use Get Data → ODBC, choose your DSN, select HubSpot tables, and click Load to start building dashboards.
Conclusion
This fast setup lets you analyze HubSpot metrics in Power BI with refreshable, query-powered dashboards.
👉 Read the full tutorial with screenshots:
https://community.zappysys.com/t/how-to-connect-hubspot-in-power-bi/405
Top comments (0)