Pull data from Hubspot into PBI via API

[randika118]

Hi,

Can anyone help me to find a solution to integrate with Huspot and PowerBI? 

Thanks,

[GilbertHall]

When working with HubSpot data in Power BI, API limits can slow things down if you request too much data at once or refresh too frequently. HubSpot’s API often returns nested JSON, so expect to spend some time flattening and transforming the data before it’s ready for reports. Splitting queries into smaller parts or filtering data helps keep things manageable. If you want to skip coding, tools like Skyvia can handle syncing HubSpot data to a database automatically, making reporting easier and more stable.

[ReportMaster]

Hi @randika118 As a workaround, maybe you can use a 3rd party connector, 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. 

[Aryna]

Hi @randika118 , you can try Power BI connector. Here is one of the providers: https://vidi-corp.com/

[amitchandak · Accepted solution]

@randika118 , Refer if this can help

https://www.techrepublic.com/article/connect-power-bi-hubspot/

https://community.fabric.microsoft.com/t5/Developer/Pull-data-from-Hubspot-into-PBI-via-API/m-p/2615...

https://community.hubspot.com/t5/APIs-Integrations/Connecting-Hubspot-to-Power-BI/m-p/232919

[randika118]

Hi @amitchandak , 

Thanks. Cant we use Hubspot REST API to connect with PowerBI?