The Power BI feed

The Power BI feed lets your reporting tools read Insights directly. School admins make a feed key that can only read the feed. It works with or without the Integrations pack.

How to create a feed key

1. 1Step 1: Open Insights, then the Power BI feed tab.
2. 2Step 2: Under Create a feed key, give it a Name (what uses it), such as "Power BI: board report".
3. 3Step 3: Set Stops working after: 90 days from today unless you change it, a year at most.
4. 4Step 4: Choose Create key, then copy the key straight away. It's shown once and never again.

How to connect Power BI

1. 1Step 1: In Power BI Desktop, choose Get data → Web, then Advanced.
2. 2Step 2: In URL parts, paste a table's address from The tables, with ?format=csv on the end (for example the site-months table).
3. 3Step 3: Under HTTP request header parameters, add Authorization with the value Bearer, a space, then your key.
4. 4Step 4: When Power BI asks how to connect, choose Anonymous (the key in the header is the sign-in), then Load. Repeat for each table you want.
5. 5Step 5: Publishing to the Power BI service: in the dataset's settings set the data source to Anonymous, tick Skip test connection, then schedule the refresh.

Prefer JSON? The page shows Power Query code to paste into the Advanced editor.

The tables

• sites: each site's id, name, state and status.
• site-months: by site and month (and your school's own hours): hours and where they came from, injuries by outcome, days lost, gate refusals and overrides, inspections done and scheduled, findings, corrective actions and diary days signed off.
• site-days: the same daily events by site and day, plus that day's snapshot (compliance, open and overdue items, coverage, SDS currency, assets due).
• injury-rates: LTIFR, MTIFR and TRIFR by site and month, for the month and the rolling 12 months, with the counts and hours behind them.
• findings-months: findings by site, month, type and category: raised, closed, overdue and average days to close.

Choose the range with ?from= and ?to=: months (36 at most, the last 12 by default) or, for site-days, dates (93 days at most). One site: ?site= and its id.

Revoke a key

1. 1Step 1: In Feed keys, open Revoke beside the key.
2. 2Step 2: Type Why, then choose Revoke now. It stops working straight away.

Limits

• 120 requests a minute per key.
• A key stops working when it ends, is revoked, or Insights is switched off.
• The list shows each key's first characters, when it ends, when it was last used and its state (Active, Revoked or Expired).