Power BI live sync

Your SMID data, ready in Power BI.

Connect Power BI to SMID through a secure API and turn the data your school or trust already uses into tailored dashboards, comparisons and reporting views.

Explore dashboard examples How to add capture IDs
Secure API connection School and trust reporting No repeated CSV exports
Example SMID data displayed in a Power BI dashboard
Connected to SMID Refresh Power BI to retrieve the latest selected data
How the sync works

A secure connection, built around the data you choose.

Power BI sends authenticated requests to SMID whenever the dataset is refreshed. Your credentials confirm the connection, while Data Capture IDs control which capture-specific data is included.

  1. 01

    Enable API access

    SMID enables the integration for your school or trust and gives an administrator access to the Power BI setup area.

  2. 02

    Add secure credentials

    Generate an API key and secret, then add those values and your school code to the example Power BI file.

  3. 03

    Add your Data Capture IDs

    List the numeric IDs for every capture you want to report on. If an ID is not included, its capture-specific data will not appear.

  4. 04

    Refresh in Power BI

    Apply the query changes and refresh. Power BI retrieves the authorised SMID data and updates the connected report model.

What is possible

Explore an example Power BI report.

Browse all 15 pages from the example report. The data is fictitious, but the dashboards show the range of school, trust, pupil, subject, attendance and benchmarking views you can build.

Example Power BI report page 1: Example Power BI snapshots
Page 1 of 15

Example Power BI snapshots

Fictitious data showing the range of dashboards and analysis that can be built.

Want to review every example offline? Open the complete example PDF
Do not miss this step

Add the right Data Capture IDs.

Data Capture IDs tell the Power BI connection exactly which assessment snapshots to load. Add each required ID before refreshing so your chosen terms, year groups and comparison points are available.

  1. Find the ID in SMID. Open the relevant year group's Data Captures page and expand the capture you want to use.
  2. Add it in Power BI. Choose Transform data, open the Data Capture table and add the numeric ID as a new row.
  3. Apply and refresh. Save the table changes, apply the query updates and refresh the report.
How to add a Data Capture to Power BI 1 minute 25 seconds
Built around your reporting

Start with the example, then make it yours.

Use the supplied connections as a starting point, customise the report around your priorities, or ask SMID to collaborate with your school or trust.

Talk to SMID