Arbor’s Microsoft Power BI Connector

Our Microsoft Power BI Connector automatically syncs your Arbor data into Power BI through Snowflake, so you can customise and visualise it however you need to. Please note, our Connector comes with a fair use policy.

  • Ready to go - Your key Arbor data is pre-loaded in Microsoft Power BI, which means no need for a manual export.
  • Templates to get you started - We’ve created five template dashboards giving you the key information you need to dig deeper into questions about your performance, from attendance to assessment to behaviour.
  • More customisation - Bring your Arbor data to life with powerful visualisations in Microsoft Power BI, and pull in any other data you want to build the insights you need.

We are continuously building on this feature to enable you to export more data in the future.

What templates are available?

We’ve created a template that gives you 5 ready-made dashboards:

  • School/trust dashboard built with an overview of your Key Performance Indicators (KPIs)
  • Attendance
  • Assessment
  • Behaviour
  • Demographics
What data is available?

Data synced from Arbor to Power BI:

You can see a full list of what data is available here: Microsoft Power BI Connector Datasets

This includes:

  • Student data
  • Academic Year enrolment
  • User Defined Fields (UDFs)
  • Registration form information
  • Student demographic data
  • SEN Status information
  • Attendance statutory roll call marks
  • Behaviour incidents
  • Exclusions
  • Summative assessment raw grades, targets and baselines
  • Exam results
  • KS4 Exam analysis
  • Attainment 8 and EBacc assessment analysis
  • Standardised DfE assessments - including DfE assessments, Hodder and Granada Learning (UL schools only)
  • Staff data
  • Academic Units and their Enrolments
  • Timetable Slots and Timetable Slot Staff

You can see a full list of what data is available here: Microsoft Power BI Connector Datasets


Before setting up the Connector

Our Connector can be purchased as a standalone feature and isn't included by default in our packages. To discuss your upgrade options, get in contact at

The Connector is designed for experienced Power BI users, so make sure you’re confident using the platform first. There’s some useful information on the Power BI website.

Support with the Connector:

  • If you have any issues with the Arbor side of the Connector (e.g. not all your Arbor data is synced), please contact the Arbor Support Team if supported by Arbor, or your Support Partner if not supported by Arbor.
  • If you have any queries about how Microsoft Power BI works, please contact the Microsoft Power BI Community.


How to set up the Connector

Once you've purchased the feature and we've sent over your credentials (including server name and warehouse) via email and the templates, watch the video below to see how to set up the connector.

Setting up Arbor's Power BI Data Connector

The video above shows how to add in your credentials and connect your data to Microsoft Power BI.


Attainment 8 and EBacc assessment analysis

Our Key Stage 4 summative assessment analysis available through our PowerBI data sets takes the hard part out of analysing your data. It includes the data drop by data drop calculation Attainment 8 and EBacc scores, and 'eligibility' flags (whether the student’s spread of assessments makes them eligible for EBacc).

How to set up your assessment analysis

To be able to use assessment in your analysis, make sure the assessments have been set up using Arbor's out-of-the-box Progress 8 assessments, with one of the out-of-the-box grade sets. Other assessments set up or set up with custom grade sets cannot be used. If you modify the out-of-the-box grade sets, your results may be skewed. You can see how to set up assessments here: Setting up and analysing Progress 8 Assessments

Check you've set these up correctly by going to Students > Assessments > Annual Policy > Manage Assessments. You can see whether it's a Progress 8 assessment here, and click on it for more information.



You can see some example screenshots of how it will look below.



Was this article helpful?
3 out of 5 found this helpful
I'm still stuck!



Article is closed for comments.