Power BI Connection to HubSpot

[Nicolas947]

Hello everyone,

I got this PowerBI project where I need to gather the data from HubSpot but Im not really familiar with this procedure. Can someone please detail on how to do this?

Appreciate your help

Have a nice day

[OscarTh]

When you’re pulling HubSpot data into Power BI, hitting API limits can happen if you grab too much at once or refresh too often. HubSpot’s API returns nested stuff, so you’ll probably need to flatten and clean it up in Power Query before using it. Breaking your queries into smaller chunks or filtering the data upfront really helps. If you want to avoid the hassle of coding, tools like Skyvia can sync your HubSpot data to a database, making your Power BI reports run smoother and faster.

[QueryWhiz]

Hi @Nicolas947 As a workaround, maybe you can use a 3rd party connector, which pulls data directly from the Hubspot API, it can save you a lot of time compared to other options. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Hubspot connector in the data sources list:

After that, just grant access to your Hubspot account using your credentials, then on preview and destination page you will see a preview of your Hubspot fields:

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

[Anonymous]

Hi @Nicolas947 ,
I just wanted to kindly follow up to see if you had a chance to review the previous response provided by @rubayatyasmin  . If the response addressed your issue please Accept the answer so that it will be helpful to others to find it quickly.If still needed assistance, feel free to reachout.

Thank you for being a part of Microsoft Fabric Community Forum!

[rubayatyasmin · Accepted solution]

Hi @Nicolas947 

Try to use connector or csv export. Refer: How to Connect Hubspot to Power BI? 2 Easy Methods | Hevo

to use open source connector, see https://www.youtube.com/playlist?list=PLI3w6pdNV1sR3foUBnwl15rU_uthKkjS8

Also check, Power BI Integration HubSpot Integration | Connect Them Today