Forum Discussion

ldiaz's avatar
ldiaz
Frequent Visitor
9 years ago

Power BI & Harvest API

Looking for some assistance with integrating the Harvest API (getharvest.com) with the Power BI API. I'm not nearly savvy enough to do this on my own but I know someone here probably is. Any ideas fr...
Need Help
Show and Tell
ldiaz's avatar
ldiaz
Frequent Visitor
9 years ago

Thanks for your quick reply Eric_Zhang. Sounds like option #1 would be the most feasibly solution for me. I'll have to give that a try. Gateway has really never worked for me; I think this is a security issue on our network. I might just keep the data in OneDrive for Business and schedule the refreshes that way. Thanks for your suggestions/assistance!

ChLa's avatar
ChLa
New Member
8 years ago
Hi @Idiaz

How did your test go - did you manage to connect to Harvest directly from Power BI? I currently have the same challenge and would love to hesr your experience..? Regards Chris
  • omarkus's avatar
    omarkus
    New Member
    8 years ago

    I had the same need.

    It's actually pretty comliplicated to connect BI tools directly to Harvest. I ended up building a separate application that connects to the Harvest API and pulls all data to a separate database, which I then connected to my BI tool. Happy to provide more details on the solution.

    • CleverUsername's avatar
      CleverUsername
      New Member
      8 years ago

      Hi Omarkus,

       

      I am very interested in your solution through building a separate application. That sounds very interesting.

    • BC_OPS's avatar
      BC_OPS
      New Member
      8 years ago

      Hi omarkus, 

       

      Very keen to understand how you did this. I am trying to do a very similar thing. 

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      it definitely is complicated. I always get stuck at the authentication step. not sure if its power BI or Harvest.