Power BI integrations

Power BI integrations

→

Nmbrs → Power BI

Nmbrs to Power BI integration: HR and payroll data ready for reporting per company

→

AFAS Profit → Power BI

AFAS to Power BI integration: HR data from Profit in Power BI, with history and its own security

→

Workday → Power BI

Workday to Power BI integration: global HR data in Power BI, with retroactive changes handled correctly

→

Visma Raet YouForce → Power BI

YouForce to Power BI integration: HR and payroll data from Visma Raet in one reporting model

→

HiBob → Power BI

HiBob to Power BI integration: people data and work history from Bob in Power BI

→

Personio → Power BI

Personio to Power BI integration: employees, absence and pay costs from Personio in Power BI

Systems you can connect Power BI with

How KoppelHet connects to Power BI

KoppelHet stages HR and payroll data daily in a database that Power BI reads, so reports do not run directly against the HR API.

Objects we connect

• Employees and headcount
• Payroll cost per cost centre
• Absence and turnover

What a Power BI integration does

• AFAS Profit, Visma Raet YouForce → to Power BI

  Headcount and turnover from HR

  Employees and employments from AFAS or YouForce go daily to a database that Power BI reads, not directly against the HR API.

  AFAS Profit → Power BI integrationVisma Raet YouForce → Power BI integration

• Nmbrs, AFAS Profit, Exact Online → to Power BI

  Payroll cost per cost centre

  The payroll journal from Nmbrs or AFAS lands in the database per cost centre, next to the budget from the finance system.

  Nmbrs → Power BI integrationAFAS Profit → Power BI integrationExact Online integrations

• Visma Raet YouForce, Visma Verzuim → to Power BI

  Absence without personal data

  Absence is included aggregated or pseudonymised, so management information is right without the report showing names.

  Visma Raet YouForce → Power BI integrationVisma Verzuim integrations

What to watch for

• Personal data is only included when the report needs it. Management information usually works with aggregated or pseudonymised data.

In your IT landscape

• Runs as a managed integration on the KoppelHet platform, next to your existing integration layer. No VPN into your network.
• Only the fields in the design you approve are transferred. The platform keeps no register of its own.
• Tested first in the test or acceptance environment where there is one. You choose the go-live moment.
• ISO 27001 certified, hosted in Amsterdam. When the contract ends you receive the configuration and the audit logs.

Implementation, architecture and compliance

Processes with this system

• HR data to BI

Topics that involve Power BI

• History by reference date
• Turnover and headcount
• Multiple employers and countries
• Security and privacy

Customer case

Articles about Power BI

• Calculating turnover in Power BI from your HR system
• Why does an old HR report in Power BI change?