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

[karaoan]

@FN  you might want to try out Acterys (https://www.acterys.com😞 Acterys App

It creates a data warehouse with your HubSpot data on Azure SQL to which Power BI can connect to also in Direct Query mode (live link) for very fast and easy analysis. The solution also includes Power BI templates that are fully editable and enable write-back and planning.

[Leonid_Kostin]

Hi, @ranbeermakin .

I am trying to get Hubspot data to Power BI Desktop using your connector but can't make it. 

I've done step by step instruction from https://github.com/ranmax123/powerbi-custom-connectors and still don't see "Hubspot (Beta)" in the list of connectors. What could course the issue?

My local folder:

Power BI settings:

Power BI Connectors after the restart:

Thank you in advance!

[ranbeermakin]

Hi @Leonid_Kostin . Thanks for trying out the connector.

That's quite unfortunate to hear that you are not able to connect.

Can you:

1. Navigate to %USERPROFILE%\Documents\Microsoft Power BI Desktop\Custom Connectors. Put this under "Run" (Windows R). Does it open the same folder that you have shown me?

2. Are you behind any IT policy which is not allowing you to load non-certified connectors?

Thanks

[Leonid_Kostin]

hi, @ranbeermakin .

Answering your questions:

1. Yes

2. Don't think so.

Maybe it is something related to this issue: https://docs.microsoft.com/en-us/power-bi/desktop-trusted-third-party-connectors?

What do you think?

Thank you a lot!

[DataInsightsGrp]

I have used this in the past, but struggled to get it working.  Solution - for some reason my folder set up drops the Microsoft the file path - from C:\users<your_user_name>\Documents\Power BI Desktop\Custom Connectors\.  Once I made this edit and put the file there, it worked.

[ranbeermakin]

There is a FREE HubSpot custom data connector to Power BI available on our public GitHub Page.

Why don't you try and provide feedback?

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

You can have visualizations like this one through the data from the connector.

[Pbix_is]

Hi! I was going to try but then I saw this from HubSpot: 

After November, will this connector work? Also if they don't allow creation of keys at the moment - if I follow some steps they give for private app, will it work with your solution? Thanks a million!

[Syndicate_Admin]

This - I would like to know this too please?

[snir]

Is there an option to publish and refresh the data using this connector?
thanks!

[ranbeermakin]

Yes, you need to use a Gateway to accomplish it

[Omonye]

Hi @ranbeermakin , well done on the work you have done so far... Any news on getting Engagements, dealpipeline and other tables?

[Anonymous]

@ranbeermakin .Thank you for this, it is super helpful and I just set it up up. Does it pull in the email activity? We were hoping we could filter by email open, clicks and all of that.

[ranbeermakin]

@Anonymous thanks for trying out and providing feedback. There have been phenomenal interest in this connector and we have been bombarded with new requests. I have put this under the queue and I will let you know when this is out.

Our first priority is to get custom fields out and we are targeting end of Nov, followed by tickets and email.

Thanks

[jdormer8]

@ranbeermakin Thanks for creating that connector! It was super simple to setup and get started, great work.

I was wondering if you are still working on the custom properties update? That would make it perfect. 

Thanks again.

[ranbeermakin]

@jdormer8 yes, we are targeting Feb for custom properties and tickets data.

[Anonymous]

Hi, 

I am having a problem with the connector. It is only showing deals and accounts and no contact table. However when I installed it on my colleagues laptops it shows all three. What is the issue?

Regards, Jonathan 

[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