Hubspot Private APP

Hi Anonymous I know this reply is very late. There’s no built-in connector for Hubspot to PBI, you will have to look for another way. As a workaround, maybe you can use a 3rd party connector, it can save you a lot of time compared to the other options. I've tried windsor.ai, supermetrics (which doesn't have PBI as a destination, so you first have to export to Google Sheets and then export to PBI) 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.

Hi Anonymous , you can also try to use Power BI connectors. Her eis one of the providers: https://vidi-corp.com/

Here is also an examples of Hubspot report I developed using this connector: https://drive.google.com/file/d/1VnnFaNjECPMTqnjRs8_5h6j8MQsAV40h/view?usp=sharing

Hola @Syndicate_Admin !

You can use our Power BI open source connector for HubSpot.

All the code is available for free on GitHub here:
https://github.com/audoxcl/Power-BI-HubSpot-Connector

And here are the instructions on how to install and use it:
https://www.youtube.com/playlist?list=PLI3w6pdNV1sR3foUBnwl15rU_uthKkjS8

If you have any questions or concerns, you can contact us here:
WhatsApp: +56 9 9675 0572
Email: [email protected]

Javier Núñez
CEO & Founder
Audox
www.audox.com

Hi, rather than going through the Private App API route, have you looked at using a third-party connector? Much less setup involved and avoids the modelling headaches that come with HubSpot's data structure.

This one worked well for us: https://vidi-corp.com/hubspot-power-bi-connector/
Hope it helps!