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?
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.
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.
Check out new user group experience and if you are a leader please create your group!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates