Reporting on Harvest with Power BI
This is an accompanying walkthrough to the free Power BI app on Harvest in the Microsoft AppSource: Harvest Reporting. Easily get insights in Harvest with Power BI.
What is Harvest?
Harvest is a popular time-tracking and timesheet registration tool designed to help teams and individuals manage their time effectively. With Harvest, users can log work hours, track project progress, and generate detailed timesheet reports. It’s widely used by businesses to improve productivity, ensure accurate billing, and analyze resource allocation.
What is Power BI?
Power BI is a business intelligence and data visualization platform by Microsoft that enables users to connect to various data sources, transform data, and create interactive dashboards and reports. It's widely used by organizations to gain insights into their operations, monitor key performance indicators (KPIs), and make data-driven decisions.
Added Value of importing Harvest into Power BI
This Power BI app integrates these two powerful tools—Harvest and Power BI. It extracts data from Harvest, such as logged hours, project details, and team performance metrics, and feeds this data into Power BI. This integration allows you to create dynamic, customizable reports that provide clear insights into how time is being utilized, enabling better decision-making and project management.
By leveraging Harvest for data collection and Power BI for analysis, the app empowers users to:
Monitor time-tracking trends in real-time.
Visualize project performance and team productivity.
Optimize resource allocation and billing processes.
Use Cases
Please see below some of the reports and use cases that have been tackled with Harvest as a source.
Authenticating to Harvest from Power BI
Follow these steps to authenticate the app to your Harvest Account:
1) Navigate to the Developer section in Harvest: https://id.getharvest.com/developers
2) Press on the button ‘Create New Personal Access Token’
3) Give the access token a name, for example: ‘Power BI Access Token’
4) You’ll be granted the following information:
Token: This is the access token that’s being generated purely for this connection. Write it down and keep it secret. An example could be 3445xxx.pt.xxxxx-xxxxWA0lw
Account ID: This is the id of the account in Harvest. This typically consists of e few numbers such as 1234567
Now that you have these two pieces of information, go back to your app and input it into the information in the Power BI Template app.
Wait, I need more information!
we encourage you to contact us if you're in need of some more advanced functionalities such as:
Reporting on admin functionalities: Billable rates, project estimations, expenses, invoices, estimates, ...
Working with multiple tenants: If you've got more than one company, you're probably working with multiple tenants. We have a solution for that!
Sickness / Bradford reporting: You'll get a good glimpse of insights that you can get on illness by this report page.
Combining Harvest with other sources: Harvest might not be your single source of truth. Let us help you in bringing in more sources!
Integrations with other systems: At Plainsight, we're using time allocated on projects in Harvest to allocate financial costs to certain project in our accountancy program. Let us know if we can assist on that.
Performance Improvements / Incremental Refreshes / Technical Problems: If you're in need for a faster solution, want to implement incremental refresh or other technical improvements, we can assist you with that!
You can simply contact us by sending an email to with your inquiry: info@plainsight.pro