Integrating HubSpot with Power BI enables access to a variety of data-driven insights. Power BI is a strong platform for producing interactive data visualizations, reports, and dashboards. By linking HubSpot, you can elevate your data analyzing and reporting abilities. Here’s a step-by-step guide on how to set it up.
Prerequisites:
To connect HubSpot to Power BI, you need to have HubSpot API Key and Power BI desktop. If you don’t have a HubSpot API Key, you can generate it by following the instructions here.
Step 1: Install Power BI
The first step is to install Power BI on your desktop. You can download it for free from the Microsoft Store here. Once installed, open the Power BI Desktop to proceed further.
Step 2: Connect Power BI with HubSpot
To connect Power BI with HubSpot:
- Go to the Home tab on the menu bar of Power BI.
- Click on “Get Data”.
- On the popup window, choose “OData Feed” and click “Connect”.
Step 3: Enter the HubSpot API URL
Now, you need to enter the HubSpot API URL. The URL should look like this:
https://api.hubapi.com/contacts/v1/lists/all/contacts/all?hapikey=YOUR_HUBSPOT_API_KEY
Replace “YOUR_HUBSPOT_API_KEY” with your actual HubSpot API key. Then click “OK”.
Step 4: Load Data
Once you have entered the API URL, Power BI will retrieve the data. Click on “Load” to load the data into Power BI.
Step 5: Start Visualizing Data
Now, you can start visualizing your HubSpot data in Power BI. Select the tables and fields of your choice to create interactive dashboards and reports.
// Sample code for creating report in Power BI
report = powerbi.embed(reportContainer, settings);
And that’s it! You have successfully connected HubSpot to Power BI. You can now manipulate and visualize your HubSpot data using Power BI’s powerful data analysis and reporting features. Enjoy exploring your data!
