Skip to content

Power BI Feed

github-actions[bot] edited this page Nov 13, 2026 · 1 revision

Power BI Feed

Senior leaders often want to see whether IT is getting better, not only how it is today. Every night Groundskeeper writes down about forty small numbers (Cyber Essentials checks, updates, backups, devices, alerts, disk space, warranty and the traffic lights) and keeps them for five years. With Groundskeeper Pro your school's own Power BI can read that daily record and draw it over time.

Where the data goes

Groundskeeper never sends anything. Power BI collects the record through Microsoft's on-premises data gateway, a free Microsoft program you install on a Windows machine inside your network. Once Power BI has collected the numbers, they are held in your school's Microsoft 365, under your control.

The feed holds counts only: how many computers pass a check, how many could not be read, a light's colour as a word. It never includes the names of people, signed-in users, computer names or network addresses. A computer that has not reported is counted as unknown, never as passing. A day the server was off has no row.

Set it up

  1. Go to Settings -> Integrations, find the Power BI card, give the token a name (for example Power BI gateway) and click Make token.
  2. Copy the token straight away. It is shown only once; Groundskeeper keeps only a scrambled copy.
  3. In Power BI, connect to a web address on this server, for example https://your-server:8443/api/powerbi/v1/kpi_daily, and when asked for credentials choose Basic and give the token as the password (any user name). The gateway machine must trust Groundskeeper's certificate: run tools/Trust-GroundskeeperCert.ps1 on it if you use the default self-signed one.

The other two addresses are /api/powerbi/v1/info (the school and what the record covers) and /api/powerbi/v1/kpis (the meaning of each figure). kpi_daily accepts ?from=YYYY-MM-DD&to=YYYY-MM-DD.

Revoking

Click Revoke beside a token to stop Power BI reading the record at once. You can have up to five tokens. After five wrong tries from one address, that address is blocked for a minute.

Last updated: 2026-11-13 (v0.196.7)

Clone this wiki locally