Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 friends?
Luis
Hi All
I know this post it OLD, but I do have a Harvest Connector that I built a few years back.
I'm updating it at the moment as the API changed since I last used it.
If anyone wants to work with me on this give me a ping as I was going to open source it onto GitHub and it would be nice to have some contributors and people who want to use it.
Chris
I was in the same boat; I have the REST APIs working, but the rate limits and 429 response codes that keep popping up were so annoying.
I actually started looking around for alternatives and came across this: Tugger. They do a Harvest Integration with Power BI. I hadn't really thought about the Data Warehouse at this stage, but as they also do that, it's lookin' like a great alternative.
hey all,
Been using Postman to test the harvest GET requests. works fine. It's just too much manual work. I know a bit of coding here and there but not enough to create a script that does the run for me .
Did anyone get to a solution to this one which is more feasible?
What would you like to do when integrating the Harvest API (getharvest.com) with the Power BI?
Typical cases I think of are:
case 1: Using Power BI Desktop.
case 2: Using Power BI REST API
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!
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.
it definitely is complicated. I always get stuck at the authentication step. not sure if its @power BI or Harvest.
Hi Omarkus,
I am very interested in your solution through building a separate application. That sounds very interesting.