Spinners
HR and payroll data from Nmbrs is ready for reporting in Power BI, with contracts, job history, absence, leave balances, schedules and the average length of employment per company.
HR data to BI
Nmbrs to Power BI integration: HR and payroll data ready for reporting per company
With an integration between Nmbrs and Power BI, contracts, job history, absence, leave balances and schedules from Nmbrs sit in a fixed data model that Power BI refreshes, per company and across the whole group. HR and management then report in Power BI without merging Nmbrs exports in Excel.
What the integration does
Employers that run payroll for several companies in Nmbrs often combine separate exports in Excel to report on headcount, absence and turnover. The figures per company are then only available after a day's work and not always comparable.
- Someone with the right Nmbrs login grants the integration read access once to the companies that belong in the reporting.
- Every day KoppelHet fetches employees, contracts, job history, absence, leave balances and schedules and puts them in a fixed data model.
- After fetching, KoppelHet starts the refresh of the Power BI model, so the reports show the new position.
- Derived figures, such as the average length of employment per company, are ready in the model.
- HR and management open the reports in Power BI, with only the companies and data they are entitled to.
What to watch for with Nmbrs and Power BI
- Contracts, job history, absence, leave balances and schedules from Nmbrs can be combined in one model, with for example the average length of employment per company as a fixed measure.
- Employee numbers in Nmbrs are unique per company, not across the whole environment. In the model the key is therefore company plus number, so employee 1001 of one company does not merge with 1001 of another.
- Job and department have a start period in Nmbrs, not an exact date. The job history in Power BI therefore follows payroll periods, so headcount reports match the payslips.
- In its older interface Nmbrs supplies reports such as absence and leave as a background task that is collected later, and that interface stops on 1 March 2027. KoppelHet fetches the data through the new interface where Nmbrs offers it, so reporting does not stop.
- Power BI refreshes a model on shared capacity at most eight times a day, and refreshes through the API count too. KoppelHet therefore refreshes after fetching and after a payroll run, instead of every hour.
- Row-level restrictions in Power BI only apply to viewers, not to admins and members of a workspace. The HR model therefore sits in its own workspace, where managers are only viewers and so only see their own company or department.
- BSN, addresses and bank details are not needed for reporting and do not enter the model.
How we build and run it
- The integration runs on the KoppelHet platform, hosted in a data centre in the EU.
- Every sync and every error is visible in the functional log; on an error your administrator is notified.
- A change that cannot go through is not half-applied but queued for another attempt.
- KoppelHet is ISO 27001 certified. Data travels encrypted and stays on the platform no longer than needed.
- After go-live we manage the integration and adjust it when your process changes.
- The integration fits next to your existing integration layer. Only the fields in the design are transferred; the platform keeps no register of its own.
Implementation and price
This is not an app you switch on. We build the integration for your organisation on our platform, with building blocks we reuse on every project. So it is custom work that does not start from scratch.
A consultant prepares the intake and analyses both systems. We then record the mapping and exceptions field by field, test in the test or acceptance environment and go live at a moment you choose. Costs are a one-off amount for the setup and a monthly amount for platform, monitoring and support.
Price indication · Basic
Customer case
How it runs at Spinners
How these organisations use the integration. The configuration differs for each customer.
Frequently asked questions
Do managers only see their own people?
Yes, if they are viewers in the workspace. Per company or department we define who sees which rows.
Can we extend the model with our own reports?
Yes. The model is a regular Power BI model; you build your own reports on it. New data from Nmbrs is added by agreement.
What about the GDPR?
You are the controller and KoppelHet is the processor, under a data processing agreement. Only data the reporting needs goes to Power BI.
Technical details for IT
For those who want to know how it works under the hood: APIs, fields and sources used.
- Nmbrs is read through the Nmbrs REST API with OAuth 2.0 and read-only scopes, per company. Where the REST API does not yet supply equivalent data, through the SOAP ReportService with background tasks (such as EmployeeAbsence, EmployeeContracts and EmployeeStatutoryLeave); the SOAP API stops on 1 March 2027.
- Power BI semantic model in import mode, refreshed through the Power BI REST API. On shared capacity at most eight refreshes a day (API included), on Premium, PPU or Fabric up to 48 scheduled. Row-level security with roles per company or department; RLS only applies to the Viewer role.
Which fields are transferred
The key fields. The full mapping is agreed per customer.
| Field in Nmbrs | Field in Power BI | Notes |
|---|---|---|
Bedrijf en personeelsnummer | Medewerkersleutel | Employee numbers are unique per company |
Contracten (begin, einde, soort, uren) | Tabel contracten | |
Functie en afdeling per periode | Tabel functiehistorie | |
Verzuimmeldingen | Tabel verzuim | |
Verlofsaldi | Tabel verlof | |
Rooster | Tabel roosters | |
Datum in en uit dienst | Duur dienstverband per bedrijf | Calculated in the model |
Related
ADP Workforce Now → Nmbrs
ADP Workforce Now to Nmbrs integration: the Dutch payroll group from ADP in the right Nmbrs company
AlexisHR → Nmbrs
AlexisHR (Simployer One) to Nmbrs integration: Dutch employees into payroll
BambooHR → Nmbrs
BambooHR to Nmbrs integration: Dutch payroll next to a global HR system
Bullhorn → Nmbrs
Bullhorn to Nmbrs integration: placements with hourly pay and end date in payroll