Human Resources Power BI Report

Go to System > Extracts > Entity Maintenance.

Extracts needed from the following Entities:

HRPersonnel, HRPersonnelAddress, HRPersonnelDemographics, HRPersonnelSecure, HRPersonnelleave, HRPersonnelService, PPJobGroups, PPJobTypes, SYLookup, PRDepartment, Sysdb, GLPeriod

Search for the entities above and ensure the Extracts have been generated and data extracted into SQL tables.

To extract data from ERP+ to your SQL server you should apply the following actions in this order:

Go to System > Extracts > Views.

Select Generic Schema and create the following views:

Generic.HRPersonnel, Generic.HRLeaverReason, Generic.HRJobTitle, Generic.HRJobGroup, Generic.Sysdb, Generic.HRStatus, Generic.PRDepartment, Generic.GLPeriod

Select the Human Resource Schema and create all views as shown in the image below:

Go to System > Extracts > Reports.

Download the Power BI template and sign in with your SQL credentials and the report will automatically populate with your data.

Human Resource PBI Template Example