Hubspot Private APP

[Hashman]

So, I am having an issue where I can't seem to find a solution for transfering socials and blog analytics data from hubspot to power BI. I would like to know if there is a solution for it using any method other than the third party connector. Thanks. 

[ReportGuru]

Hi @Hashman 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 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. 

[Hashman]

This I know, but I can't get the anayltical data out of hubspot into Power Bi without a third party connector and I can't seem to find the endpoint for it as well.

[v-junyant-msft]

Hi @Hashman ,

I'm not sure exactly what you mean by socials and blog analytics data, but generally for some URLs that we want to connect to the web, we generally use the web to connect to them:

If you need to connect to some of the specified content, you may need to use the Web API (but you need to ensure that the corresponding API interface exists).

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.