Forum Discussion

FN's avatar
FN
Regular Visitor
9 years ago

Data Source Hubspot

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
Need Help
ranbeermakin's avatar
ranbeermakin
Icon for Resolver III rankResolver III
5 years ago

Hi All,

 

We just released an update to the FREE Power BI Connector to HubSpot with following updates:

 

1. Tickets object

2. Owners object

3. Associated company in contacts object

4. Associated company in deals object

 

Head to our repo: https://github.com/ranmax123/powerbi-custom-connectors

 

Direct link to the .MEZ file: https://github.com/ranmax123/powerbi-custom-connectors/tree/master/HubSpot/build


For any issues and/or enhancement requests you can open a GitHub issue.

 

Cheers,

Ranbeer Makin

 

  • acol90's avatar
    acol90
    Regular Visitor
    4 years ago

    ranbeermakin  wow, this is a really cool open source. Many thanks guys for providing this to the community.

     

    I have managed to use the .mez file into the power bi desktop and I would like to ask you a few questions:

     

    1) Can I extend the code to use some custom fields we have in our HubSpot platform? I have created a new project using the same code but after building the solution and creating the new .mez file, when replacing it into the Power BI folder, it does not appear as a connector in Power BI. Am I missing something?

    2) Would you be able to share the amazing template you posted in the GIT Hub. That Horizontal funnel/lifecycle is very cool.

     

    Thanks again

     

    • ranbeermakin's avatar
      ranbeermakin
      Icon for Resolver III rankResolver III
      4 years ago

      1) Yes, you can extend

      2) Yes, I will open source that one too

  • tj1947's avatar
    tj1947
    Regular Visitor
    4 years ago

    I'm having trouble getting the the Hubspot Ticket table to appear in the Navigator.  I'm not sure which "Column 1" the error (screen shot below) is referring to, or how to fix it.  Any ideas?

     

     

    • nicstt's avatar
      nicstt
      Icon for Helper I rankHelper I
      4 years ago

      You could try Tugger LTD's solution, as I posted previously; the example reports they include might actually provide what you need.

       

       https://tuggerapp.com

      • tj1947's avatar
        tj1947
        Regular Visitor
        4 years ago

        Appreciate the suggestion!  But I'm in a very small startup business.  Looking for a free or open source tool.

  • Omonye's avatar
    Omonye
    Frequent Visitor
    4 years ago

    ranbeermakin, please i tries this but it didn't work

  • Omonye's avatar
    Omonye
    Frequent Visitor
    4 years ago

    The you ranbeermakin , it worked

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    WOW! Can't believe that an open source PBI integration really exists, lol. 

     

    Very cool of you guys making this available, me and my company appreciate it a lot 😉

    Do you know how the data update works? I couldn't find any info about it on the repo

  • mjec009's avatar
    mjec009
    New Member
    3 years ago

    hi ranbeermakin, is this option "data safe"?  

    (I'm starting with this sync and I want my data to be safe)