Pull data from Hubspot into PBI via API

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.

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

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. 

Hello,

I know I am late to this party but maybe this can help someone in the future. You can always use a 3rd party solution to pull data from HubSpot. You could use a solution like Datawarehouse.io - HubSpot PowerBI Connector 

Hopefully this helps someone trying to get data from HubSpot to PowerBI

Hi, if you want to avoid building the integration yourself, this is the easiest way I've found to get HubSpot data into Power BI: https://vidi-corp.com/hubspot-power-bi-connector/ 

Covers all the main CRM and marketing tables, refreshes automatically every 6 hours, and comes with a free template so the data model is already done. They also offer a 14-day free trial so you can test it against your own data first.