Hubspot to Power BI integration

[SGambit]

Hey guys, I am new o all of this and I want to know how I can integrate hubspot and Power BI together for a large data set using private app. Thanks.

[Humashankar · Accepted solution]

Hi @SGambit 

Here is the highlevel outline:

• Create a private app in HubSpot to generate API keys.
• Register an Azure AD application to authenticate with Power BI.
• Use the HubSpot API to extract your large data set.
• Connect Power BI to HubSpot using the API keys and Azure AD authentication.
• Model and visualize your data in Power BI.

For more help please make use of the below given help articles.

How to Integrate HubSpot Into Power BI - Zebra BI

https://youtu.be/ep7zb8ykZjM

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards

[johnelmer · Accepted solution]

@SGambit You might consider the HubSpot Integration for Power BI, which is available in the HubSpot App Marketplace.  By using the connector, you will be able to create an automated data refresh schedule so that each time you open Power BI, the most recent HubSpot data is used to update your report.

[LSchmidt63 · Accepted solution]

As a simpler solution, tools like Skyvia can help automate the process and manage large datasets without too much manual coding. 

[RanbeerMak]

The Power BI connector to HubSpot has been upgraded to use HubSpot Private apps.

Why don't you check out my GitHub?

https://github.com/ranmax123/powerbi-custom-connectors  

Why don't you give it a try?

Best
Ranbeer M

[johnelmer · Accepted solution]

@SGambit You might consider the HubSpot Integration for Power BI, which is available in the HubSpot App Marketplace.  By using the connector, you will be able to create an automated data refresh schedule so that each time you open Power BI, the most recent HubSpot data is used to update your report.

[SGambit]

I don't want to integrate it with a third party application if there is another way on integrating both together I would love to hear you out.

[noahmckeon]

Hey @Humashankar - You may want to consider using this integration from the team at Datawarehouse.io (@johnelmer). It's a no-code solution and sounds like it might be what you're looking for.

[SGambit]

I know there is an option for third part but I really don't want to connect my data with a third party connector, I want something I don't have to pay to have my data transfered on another platform that I am already paying for.

[Humashankar · Accepted solution]

Hi @SGambit 

Here is the highlevel outline:

• Create a private app in HubSpot to generate API keys.
• Register an Azure AD application to authenticate with Power BI.
• Use the HubSpot API to extract your large data set.
• Connect Power BI to HubSpot using the API keys and Azure AD authentication.
• Model and visualize your data in Power BI.

For more help please make use of the below given help articles.

How to Integrate HubSpot Into Power BI - Zebra BI

https://youtu.be/ep7zb8ykZjM

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards