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

 

Luis

Need Help
Show and Tell

13 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago

    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'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
  • Tuney8's avatar
    Tuney8
    New Member
    4 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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? 

  • nicstt's avatar
    nicstt
    Helper I
    5 years ago

    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.