This guide complements the free Power BI app for Officient, available on Microsoft AppSource: Officient Reporting. It helps you quickly gain insights from Officient using Power BI.

What is Officient

Officient is a cloud-based HR software platform tailored for small to mid-sized businesses. It streamlines day-to-day HR operations by bringing together employee data, contract details, absences, benefits, and company assets in one centralized digital environment. With built-in automation and clear visual overviews, Officient helps HR teams save time, stay organized, and gain actionable insights into their workforce.

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 Officient into Power BI

This Power BI app connects Officient with Power BI, combining powerful HR data management with advanced analytics and reporting. It extracts essential HR data from Officient including, employee details, absences, contract types, and team structures, and integrates it into Power BI for comprehensive analysis.

This integration allows you to build dynamic, customizable dashboards that transform raw HR data into actionable insights, supporting strategic workforce planning and streamlined HR operations.

By using Officient for centralized HR data and Power BI for visualization, the app enables you to:

Analyse wage distribution, pay gaps, and detailed salary insights
Track employee demographics and workforce composition
Monitor absenteeism with metrics like the Bradford Factor

Use cases

Please see below some of the reports and use cases that have been tackled with Officient as a source.

Authenticating to Officient from Power BI

Follow these steps to authenticate the app to your Officient Account:

1) Navigate to the Developer Section in Officient

2) Press on the button ‘Manage’

3) Press on ‘generate 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 da4aXXXXXX37bXXXX0e70f0XXXXc0edXXXd0cad2.

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, in the Bearer Token section.

Wait, I need more information!

We encourage you to contact us if you're in need of some more advanced functionalities such as:

- Sickness / Bradford reporting

- Integration with other systems

- Performance improvements / incremental refreshes / technical problems

You can simply contact us by sending an email to with your inquiry: info@plainsight.pro

Do you also happen to use Harvest, Odoo or Exact Online at work? If so, be sure to check out our other template apps via the following link.

Author: Margaux Dumon

**Margaux Dumon**

Margaux Dumon is a final-year master's student in Business Economics: IT and Management at Ghent University. During her internship, she explored the fascinating world of HR data using data from Officient. The result is a detailed dashboard in Power BI that gives you an instant overview of your organization

Anxious to know what Plainsight could mean for you?

Read more “About us”
Consider “your career at Plainsight 🚀”
Any questions? “Contact us”

Reporting on Officient with Power BI