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.

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.