Forum Discussion
Power BI & Harvest API
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.
- 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.
- Design reports and publish to Power BI Serivce.
- Schdule refresh via Power BI Gateway.
case 2: Using Power BI REST API
- 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.
- Create dataset and push data via Power BI REST API.
- Create a report in Power BI service basing on the dataset in step 2.
- Keep pushing data into the dataset.
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 - 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 ChrisI 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.
Hi Omarkus,
I am very interested in your solution through building a separate application. That sounds very interesting.
