cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ldiaz
Frequent Visitor

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 friends?

 

Luis

11 REPLIES 11
nicstt
New Member

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.

smishra
Frequent Visitor

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? 

PowerBiUser11
New Member

Hi @omarkus,

 

I'm also very interested in hearing about your solution.

 

Thanks

Eric_Zhang
Microsoft
Microsoft

@ldiaz

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.

  1. Using get data->other->web to consume the Harvest API to get retrieve data. Check Get Data from Twitter API with Power Query. This demo is for Twitter but shows how Power Query calling REST APIs. As to Harvest, you can follow the same approach with Harvest specific details.
  2. Design reports and publish to Power BI Serivce.
  3. Schdule refresh via Power BI Gateway.

case 2: Using Power BI REST API

  1. Getting data from Harvest in, say C# code via the Harvest API. As this step is Harvest specific, if you have any question about this step, you shall ask for help from the Harvest support.
  2. Create dataset and push data via Power BI REST API.
  3. Create a report in Power BI service basing on the dataset in step 2.
  4. Keep pushing data into the dataset.

 

ldiaz
Frequent Visitor

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!

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

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.

smishra
Frequent Visitor

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

Hi @omarkus

 

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

 

 

Hi Omarkus,

 

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

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors