Skip to main content

Power BI report

The SMART Payroll Power BI report shows payroll and HR analytics for one company or a whole group of companies: payroll overview, payroll analysis by indicators, workforce, turnover, demographics, absence, military registration and social guarantees. One report serves English, Ukrainian and Polish users: the language follows the Power BI user's settings.

The report reads SMART Payroll data through read-only Business Central APIs (route smart/powerbi/v1.0). Statutory figures that need Business Central methodology (disability quota on the average count, critical salary threshold, and similar) are taken from the calculated HR Analytics results, so the report and Business Central show the same numbers.

Opening the report in Business Central​

Path: Power BI Reports Setup → SMART Payroll

Pick the published SMART Payroll report in Power BI SMART Payroll App (the same setup page the Microsoft Power BI apps use). The report then opens inside Business Central from these pages (search for "Power BI"):

PageReport page
SMART Payroll Report (Power BI)the whole report
Payroll Overview (Power BI), Payroll Analysis (Power BI)payroll
Workforce (Power BI), Turnover (Power BI), Demographics (Power BI)workforce
Absence and Working Time (Power BI), Timesheet Analysis (Power BI)absence and timesheet
Military Register (Power BI), Social Guarantees (Power BI)military registration and social guarantees

The setup page also links to SMART Payroll Indicators and SMART Payroll User Access.

Deploying the report and data refresh​

Business Central online. On Power BI Reports Setup, deploy the SMART Payroll report the same way as the Microsoft Power BI apps. Business Central uploads the report to the user's Power BI workspace and sets its parameters: the address of the environment, the current company and the user's language. To show a group of companies, change COMPANIES in the semantic model settings (see below).

Business Central on-premises, or a manual publish. Publish the report to a workspace (from Power BI Desktop or by uploading the .pbix). Then, in the Power BI service, open the workspace, select … next to the SMART Payroll semantic model and choose Settings:

  1. Parameters:

    ParameterValue
    BC_URLthe Business Central service address without /api: on-premises up to the instance (for example https://bc.contoso.com:7048/BC), online https://api.businesscentral.dynamics.com/v2.0/<environment>
    COMPANIEScompany names separated by ;, or * for every company the refresh account can read
    REPORT_LANGUAGEen-US, uk-UA or pl-PL: the language of the Group by list
    API_ENDPOINTdo not change (smart/powerbi/v1.0)
  2. Data source credentials: on-premises — Basic, a Business Central user with the SMA_PBI_READ permission set and the user's web service access key as the password; online — OAuth2 (organizational account). Privacy level Organizational.

  3. Refresh: run Refresh now once, then turn on Scheduled refresh (for example daily, before the working day). The server must be reachable from the internet; otherwise refresh through an on-premises data gateway.

  4. Security (semantic model → Security): every viewer must be in one of the roles, otherwise the report shows no data. Full Access — everything the refresh account reads (HR / payroll administrators); Restricted — only the companies and departments listed for the user on the Power BI User Access page; Restricted (no names) — the same without employee names. Workspace admins, members and contributors always see all data.

  5. App: to share the report, create a workspace app (Create app in the workspace) and add the audience.

Permissions​

Permission setWhoWhat it allows
SMA_PBI_READ (SMART Payroll Power BI)the account Power BI refreshes the data withruns the Power BI APIs. Payroll amounts and personal data are still read under the user's own SMART Payroll permissions.
SMA_PBI_ADMIN (SMART Payroll Power BI Admin)payroll / HR administratormaintains the Power BI payroll indicators and the user access list.

Power BI payroll indicators​

Path: Power BI Payroll Indicators

On the Payroll analysis page the user picks indicators and groups them by any combination of department, company, job title, gender, age, tenure and other dimensions. An indicator is a saved filter on posted payroll entries:

FieldMeaning
Element Code / Type / Group Filterwhich payroll elements the indicator sums (Business Central filter syntax).
Work Mode Filter, In Staff, Payment Sourcenarrow the entries further.
Calculation bythe period the amount belongs to: the posting period, the wage period or the payment period.
Value Typepayroll amount, taxable amount, payment days or payment hours.
Absolute Valueshows deductions and contributions (stored negative) as positive figures.
Indicator Group, Sort Orderhow indicators are grouped and ordered in the report's indicator list.

Actions:

  • Create Default Indicators — creates gross pay, deductions, employer contributions and net pay.
  • Copy from Payroll Reports Setup — copies the data lines of a payroll report (for example the payslip) as indicators. Only lines that read posted amounts are copied; calculated lines are skipped.

Power BI user access (row-level security)​

Path: Power BI Payroll Indicators → Power BI User Access

The report has three roles, assigned to people in the Power BI service:

RoleSees
Full Accessevery company and department the refresh account can read.
Restrictedonly the companies and departments listed for the user on this page.
Restricted (no names)as Restricted, but employee names are hidden — aggregated figures only; Employee is not offered in Group by.

For users in the Restricted roles, add one line per company (the list is kept in each company):

  • User Principal Name — the user's Power BI sign-in name (e-mail).
  • Org. Unit Code — the department the user may see, with all its subordinate departments. Leave it empty to give the whole company.

A user without a line sees nothing of that company. The list is read on every data refresh. Amounts, hours and absences are limited by the department of each record, so a manager sees the people who moved out of the department for the time they worked in it, and the people who moved in only from the date they arrived. Figures as of today (military register, social guarantees, data quality) count only the employees whose current department the user may see. Company-level figures — the reservation and disability quotas and the HR Analytics indicators — are not shown to a user limited to departments.

What the report shows​

  • Report month. The Report month list in the header is one list of months for all companies; several months can be picked. Without a pick, the period pages (payroll, workforce, turnover, demographics, absence) show the latest closed payroll month of the selected companies. A picked month is shown as is, even if a company has not closed it yet. Amounts are summed over the picked months, point-in-time figures (headcount, FTE) are taken at the end of the last picked month, and the comparison is with the same number of months before. The 24-month trends end at the report month.
  • Window. The payroll analysis and timesheet pages have a Window selector: 1 month (default), 3 months, year to date, 12 or 24 months, ending at the report month. The timesheet includes days up to today.
  • Reset. The reset button returns the page's selectors to their default state (indicator set, grouping, window).
  • Amounts from the payroll ledger. Gross pay, deductions, employer contributions, net pay and the basic and variable pay of pay transparency are the elements of the Power BI payroll indicators chosen on the Power BI Reports Setup page (Gross Pay Indicator, Deductions Indicator, Employer Contributions Indicator, Net Pay Indicator, Basic Pay Indicator, Variable Pay Indicator). When a field is empty, the default indicator GROSS, DEDUCTIONS, EMPLOYER, NET, BASIC or VARIABLE is used (create them with Create default indicators on the Power BI Payroll Indicators page); without it, the element types (Wage and Bonus; income tax, tax deduction, deduction and military levy; Funds; Netto Salary; Wage; Bonus). To leave, for example, the benefits paid from social insurance out of gross pay, set the indicator's element filters.
  • Moves inside the group. With several companies selected, a person terminated in one company and hired in another selected company within 31 days is neither a termination nor a hire of the group (turnover, hires and terminations); each company on its own still counts them.
  • Long leave. Maternity leave (pregnancy sick leave) and childcare leave are shown as a separate series Maternity and childcare, not in the sick-leave and vacation days, so one long leave does not swing those figures.
  • Status as of. The military registration and social pages show the state on the date the data was read from Business Central (shown in the header), not the date the report is viewed.
  • Currencies. Amounts of companies with different local currencies are never added up: when the selection mixes currencies the amounts are hidden and the header asks to select companies with one currency.
  • Quotas. The reservation quota and the disability quota are per company. In a group the report shows how many companies exceed or miss their quota instead of netting one company against another; with a department filter the quota is not shown, because it is set for the company.
  • Anonymity. Averages, medians and shares of people (pay, age, gender, compa-ratio) are hidden for groups smaller than the Power BI Min. Group Size on the Power BI Reports Setup page (per company; with several companies the strictest applies; 0 turns the protection off). Counts and totals are always shown. The setting is independent of HR Analytics.
  • Departments. Departments are shown as a tree starting from the company; picking a department includes its subordinate departments. Department names repeated in several companies are shown with the company name.
  • Drill-through and tooltips. Right-click a department on any chart and choose Drill through → Department profile; hovering a department shows its headcount, labor cost, turnover and absence rate.
  • Filters pane. Person and employee attributes (gender, age, tenure, education, disability, family status, citizenship, military status, reservation status) can be filtered on every page, dimensions 1 and 2 on the payroll pages (they filter payroll amounts only); the active filters are listed under the page title.
  • Timesheet analysis. Hours, days and employees by time activity and by time activity group (groups as set up in Business Central; an activity can belong to several groups — when several groups are selected, each activity and each employee is counted once), grouped by department, job title, employee, dimensions and other breakdowns. The last three years are loaded. Which groups are analysed is set on the Time Activity Groups page with Show in Power BI (when no group is marked, all groups are analysed).
  • Dimensions. Payroll amounts can be grouped and filtered by the dimensions of the General Ledger Setup (shortcut dimensions 1-8), shown under their own names. The report uses the dimension sets the Microsoft Power BI app prepares (job queue entry Update Power BI Dimension Set Entries), so that job must run.
  • Grouping by the month's attributes. In Group by, Job title, Category, Age and Tenure are the employee's values in the month the amount or the hours belong to: the job title and category in force at the end of that month (from the employee's job history), age and tenure at the end of that month. Pay of an employee promoted last year therefore stays under the old job title for the months before the promotion. Job title (current) and Category (current) group by today's employee card. The person and employee attributes in the Filters pane are the current ones.
  • Pages. Move between pages with the Power BI page list. Power BI cannot translate page names, so they are in English; titles, captions and labels on the pages follow the user's language.
  • Language of the grouping list. Power BI cannot translate the items of the Group by list for each viewer. They are shown in the language of the user who deployed the report from Business Central (English, Ukrainian or Polish; English for other languages). The preset button names are in Ukrainian.
  • Presets. Buttons on the payroll analysis and timesheet pages switch the grouping in one click (by department, job title × gender, dimension × department, employees).
  • Phone layout. Every page has a one-column layout for the Power BI mobile app.
  • Group overview. One row per company: currency, report month, data date, headcount, FTE (sum of position rates), labor cost and labor cost per FTE, average pay, turnover, absence rate and the number of HR Analytics indicators in critical or warning state. People in the group is the sum of the companies' headcounts at the end of the report month with a person employed in several group companies counted once (same person number); the caption shows how many of them work in several companies. Selecting Critical indicators opens the list of HR Analytics indicators in critical state or with a warning.
  • Payroll forecast. Gross pay and employer contributions for a quarter or a year after the report month (selector Horizon). Method: each future month = the same month a year before × the pace (gross pay of the last 3 closed months against the same 3 months a year before); employer contributions = forecast gross pay × the employer rate of the last 3 months. The method keeps the seasonality (vacation pay, December bonuses) and every figure can be traced to last year's payroll. The page also shows how accurate the same method would have been a year ago (error of the horizon total, next to the error of the plain "same months last year" forecast and the average monthly error), the forecast made a year ago against the actual months, and the forecast by department. Forecasts are not taken from HR Analytics.
  • Pay structure. The page has no report month: as of the date the data was read: the monthly salary of the staff position each employee holds (primary job, in staff), counted only for positions paid with a monthly salary element of Human Resources Setup (salary by days, hours or amount; hourly and daily rates, civil contracts and piecework are left out). P10, median and P90 by job title (hidden below the Power BI Min. Group Size and when companies with different currencies are selected), the spread P90 / P10, and the compa-ratio of each employee: salary divided by the median salary of the same job title in the same company (shown when the job title has at least two employees), grouped in bands below 0.80, 0.80–0.95, 0.95–1.05, 1.05–1.20 and above 1.20.
  • Pay transparency (EU directive 2023/970, art. 9). For the reporting year — 1 January to the report month (select December for the annual report): the gender pay gap of mean and of median hourly pay, the gap in basic pay and in complementary or variable pay (among the workers who receive it), the share of women and of men receiving variable pay, the share of women and men in each hourly-pay quartile, and the gaps by job title (category of workers). A worker is a person in the company (all the person's employee cards together); in the breakdowns by department and job title the person counts once — in the department and job title of the largest pay of the last month with pay. Hourly pay of a worker = basic + variable pay (the Basic Pay Indicator and Variable Pay Indicator, by default Wage and Bonus elements) ÷ timesheet hours of the Pay Transparency Hours Group (Power BI Reports Setup; when empty, the work time group of Human Resources Setup — the hours of the timesheet status Actual Work Hours). Gap = (men − women) ÷ men. Figures are hidden when fewer women or men than the Minimum Group Size are in the group, when companies with different currencies are selected, or when no report month is available.
  • Vacation and overtime. As of the date the data was read: unused vacation days of the employees employed that day, counted by Business Central exactly as the HR Analytics Vacation Liability indicator counts them (days earned by the date minus used, compensated and adjusted days), the days left from working years that have already ended, the vacation reserve as HR Analytics Vacation Liability counts it (its element filters and Amount Field: by default the reserve balance in the taxable amount of the latest calculated month up to the report month); overtime hours since 1 January against the yearly limit of the HR Analytics OT Yearly Limit Compliance indicator (its overtime activity group, limit and warning level — set the limit there), with the number of employees over the limit and approaching it, and the number who would exceed it by 31 December if the pace continues (hours from 1 January to the end of the latest closed payroll month — the timesheet of the open month is usually filled at its end) (column "By 31 Dec" in the employee list). Breakdowns by department, vacation type and employee.
  • Data quality. Checks of the data the report relies on, each with the number of failing records, the number checked and where to fix it in Business Central: active employee cards (primary job) without a person card, birth date, gender, department, job title or category; active people without an education level (as in HR Analytics); job entries of the last 12 months without an employee and job entries of an employee card that no longer exists; payroll entries of the report month without a department; monthly payroll periods left open before the latest closed one. The page lists the employees with gaps and counts them by department.
  • Payroll control. A bridge of gross pay from the month before to the report month (when several months are picked, the last picked month against the month before it) (new in payroll — paid this month but not the month before, left payroll — paid the month before but not this month, retroactive accruals for earlier periods, bonuses, rates and other changes; these are people appearing in or leaving the payroll, not hires and terminations) and a list of people to check before closing the payroll: paid after termination, pay growth above a threshold chosen on the page, negative net pay, and monthly salary that differs from the timesheet by more than a tolerance chosen on the page (expected salary = monthly salary of the staff position × position rate × actual ÷ planned work days of the employee's timesheet; compared with the salary elements of Human Resources Setup paid for the primary job; employees hired or terminated within the report month are not checked). A person with employee cards in several companies is shown once, with the issues of all cards.
© 2008 - 2026 SMART business