Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.