Data Source Hubspot

[FN]

Hi there,

I am wondering if there is any opportunity to get data out of Hubspot into my BI reports.
Do you know something?

Regards,

Florian

[ranbeermakin]

hi @Anonymous thanks for trying out the custom connector.

1. Can you copy the latest .mez file from github to your local path? 

2. Re run Power BI, go to GetData->Online Services->HubSpot and then tick "Contact". It would pull "Contact" table for you. 

Let me know how it goes.

[BayardBradford]

Does your connector work with the cloud version of Power BI that is included with Office365? 

[ranbeermakin]

Yes, ofcourse!

[skylar]

@ranbeermakin 

Hi, I am using your connecter. It is really good.

But just a quick question. Am I able to get the ticket information as well, as right now it only shows the account, contact and deals.

Also I realise that not all the properties i created appear on the Power Bi.

Thanks a lot.

[ranbeermakin]

@skylar tickets are now integrated in this connector. Why don't checkout our github page?

https://github.com/ranmax123/powerbi-custom-connectors

[ranbeermakin]

hi @skylar thanks for trying out the connector. Glad that it helps you.

On the properties one, could you let me know which all properties you want us to include?

Are you looking to include custom properties? 

On the tickets one, could you let us know what details you are looking for in that? What ticket properties?

Let us know so we can help further.

[skylar]

@ranbeermakin 

Thanks for the reply. 

Yes I need some custom properties for both tickets and customers.

[jimenez3]

Until Hubspot connector is not created you can try the following approaches:
- Expose Hubspot data to OData with help of Skyvia Connect.
- Replicate Hubspot to any database (BigQuery, SQL Server, etc.) and use standard PowerBI database connector.

[BayardBradford]

My firm, Bayard Bradford, is a HubSpot agency partner. We offer a SaaS HubSpot API integration for PowerBI. More information can be found here.

[Matityahu10]

Can I have more details on your HubSpot API integration with PowerBI?

Thanks

([email protected])

[BayardBradford]

Please look here for information on our HubSpot connector for Power BI. We provide a low-cost, purpose-built integration service that includes a data warehouse that is optimized for HubSpot Sales, CRM and HubSpot Marketing data.

[nish_kadi]

There is no native connector pack. Have you considered using a 3rd party tool like datadirect cloud to accesss your Hubspot data as an OData feed? For example: https://www.progress.com/odata/hubspot .  Once you produce OData, accessing OData from Power Bi should be straight forward. Here is a tutorial: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-connect-odata/ 

[Anonymous]

@FN,

An idea about adding HubSpot data source in Power BI has been submitted in this link, please vote it up.

In addition, you can consider to create ODBC data source by after installing the HubSpot ODBC Driver, then connect to the ODBC data source in Power BI Desktop.

Regards,

[Greg_Deckler]

No native connector or app (content pack) but if they provide some kind of REST-based API or OData endpoint then you should be in luck.