Reporting with Power BI

The project traffic light in the monthly report, calculated by Linetrack.

Management and controlling want traffic light, schedule adherence and utilisation in the report they open every month anyway. Power BI fetches these values through Linetrack's KPI API, calculated exactly as in the project list and KPI dashboard. Using the order number, you place them next to order value and invoicing status from the ERP.

Via the REST APIKPI API with kpis:readScheduled refreshJoined by order number

Power BI website ↗

In short

Power BI reads KPIs from Linetrack through the KPI API of the REST interface, with an API key in the X-API-KEY header and the scope kpis:read. Per project it provides completion, traffic light, open and overdue tasks, schedule adherence, time progress and phase; per resource group and month it provides net capacity, planned hours and the difference. Power BI's Web connector makes the call, and the Power BI service refreshes the data on a schedule.

What Power BI can fetch

KPIs that Linetrack has already calculated

The KPI API returns the values as Linetrack shows them in the project list and KPI dashboard, so your report does not have to rebuild the traffic light or schedule adherence. For deeper analysis, projects, tasks and planned hours come from the REST API.

kpis:readProject

Project traffic light and progress

For each project you get completion, traffic light, time progress and phase, each with order and item number. The values are available for a single project, for all running projects in one call and aggregated for the whole company.

  • Completion
  • Traffic light
  • Time progress
  • Phase
  • Order number
  • Item number

In Linetrack: the same values as in the project list and KPI dashboard

kpis:readDates

Schedule adherence and overdue tasks

How many tasks are open, how many have already passed their date and how well a project keeps to its schedule. In the management report this becomes the short list of orders that need discussing before the delivery date.

  • Schedule adherence
  • Open tasks
  • Overdue tasks
kpis:readCapacity

Capacity per resource group and month

For mechanical design, electrical design, assembly or commissioning, the API returns net capacity, planned hours and the difference for each month. Over- or under-coverage shows up months before day-to-day work feels it.

  • Resource group
  • Month
  • Net capacity
  • Planned hours
  • Difference

In Linetrack: widget “Utilisation per resource group” in the KPI dashboard

projects:readPlan data

Projects, tasks and planned hours

For deeper analysis, the REST API returns projects, tasks and milestones with their dates, plus planned hours per task and resource. That gives you, for example, an overview of every FAT date in the next quarter.

  • Projects
  • Tasks
  • Milestones
  • Planned hours per resource
ERPData model

A bridge to the ERP figures

Every project carries its order and item number. In the Power BI data model you use them to join Linetrack KPIs with order value, invoicing status or contribution margin from your ERP.

  • Order number
  • Item number
  • External ID
API keyLog

A dedicated key for the report

An administrator creates a key under company administration → API keys that gets kpis:read only, plus projects:read if needed. It belongs to a technical account that uses no user licence, and every call is logged.

  • X-API-KEY
  • kpis:read
  • projects:read

In reporting

Three reports that used to be manual work

The management monthly review

Before the monthly review, management opens the Power BI report instead of phoning five project managers. Every running order is listed with traffic light, phase and schedule adherence. The discussion is about the two red projects, not about whose list is the most recent.

Capacity outlook for electrical design

Controlling sets the planned hours of electrical design for the next six months against its net capacity. The autumn shortfall is in the report before sales commits to the next order with a short lead time.

Progress next to invoicing status

Via the order number, completion and traffic light from Linetrack sit next to the partial invoices from the ERP. A project that is largely invoiced but only half finished stands out in the report, not at the post-calculation.

Setup

How Linetrack gets into your Power BI

  1. 1

    Create a key

    An administrator creates an API key with kpis:read in Linetrack. If tasks and planned hours should go into the report too, add projects:read.

  2. 2

    Query in Power BI Desktop

    Via “Get data” and the Web connector you enter the address of the Integration API and pass the key in the advanced options as the X-API-KEY header. Power Query turns the JSON response into tables.

  3. 3

    Build the data model

    You join KPIs, resource groups and ERP data on order number and month. Traffic light and schedule adherence are taken over as they are, not recalculated in DAX.

  4. 4

    Schedule the refresh

    After publishing, you set credentials and a refresh schedule in the Power BI service, for example every morning before work starts. For the service to refresh on schedule, the base address in the query stays fixed and the path is passed via RelativePath.

Practical examples

How do machine and plant builders use the Linetrack Power BI integration in practice?

Linetrack delivers traffic light, schedule adherence and capacity through the KPI API, and Power BI turns them into a report. Two typical cases are the group report of a machine-building group and monthly bank reporting in plant engineering.

Group with several machine-building plants

One group report instead of plant lists

Starting point
A group runs several machine-building plants that plan their orders in Linetrack. For group management, controlling assembles an overview every month from the plants' own lists. Each plant counts “overdue” slightly differently.
How Linetrack is used
An administrator creates an API key with kpis:read. Controlling uses it to pull traffic light, phase, schedule adherence and overdue tasks per project into Power BI with the Web connector. The assignment to a plant comes from the ERP data already in the data model, via the order number. Through row-level security in Power BI, plant managers see only their own plant, while group management sees all of them.
Result
All plants are read with the same KPIs, as Linetrack shows them in the project list and KPI dashboard. Controlling no longer rebuilds a traffic light or waits for reports from the plants. A plant with delays shows up in the group report after the next refresh, without anyone having to clarify how it was counted.
Linetrack in machine and plant engineering →
Plant engineering with monthly bank reporting

Project status for the bank, without collecting lists

Starting point
A plant builder reports to its financing bank every month on running large projects. For this, controlling asks the project managers for phase, completion and critical dates and merges them into one table. Things often still change before the cut-off date, and the table is out of date by then.
How Linetrack is used
A Power BI report reads completion, traffic light, phase and overdue tasks per project through the KPI API. With projects:read, the milestones are added, such as FAT, shipping and acceptance per plant. The refresh runs on the morning of the cut-off date, and controlling reviews the red projects and adds its comments in the report.
Result
The bank report rests on the same state that project management maintains in Linetrack. Queries to the project managers are limited to projects with delays. Controlling spends the cut-off date interpreting the figures instead of gathering them.
Large projects in plant engineering with Linetrack →

Examples without a reference label describe typical workflows in the respective industry and therefore name no company.

FAQ

Frequently asked questions

Any questions?

Book a call with our team.

Does Power BI calculate the traffic light itself?

No. The KPI API delivers the traffic light, schedule adherence and the other KPIs as Linetrack calculates them. The project list, the KPI dashboard and your report therefore show the same values.

How current are the figures in the report?

As current as the last refresh of the semantic model. Each call to the API returns the current state in Linetrack. How often Power BI calls it is set by the refresh schedule in the Power BI service.

Does every report reader see all projects?

The API key reads your company's KPIs. Who may see the finished report is controlled in Power BI through workspace and sharing, with row-level security for individual areas if needed.

Is there an option without Power BI?

Yes. The KPI dashboard in Linetrack shows the KPIs directly, and the widget “Utilisation per resource group” exports an Excel file with a data table and an editable Excel chart. For a monthly report without a BI tool, that is often enough.

The platforms and brands mentioned belong to their respective owners. Mentioning them describes the technical connection and does not imply a partnership or certification.