Arbor’s Microsoft Power BI Connector

Our Microsoft Power BI Connector automatically syncs your Arbor data into Power BI, 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 will be 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:

  • Student data
  • Attendance - raw AM/PM attendance marks
  • Behaviour incidents
  • Exclusion data
  • Summative assessments
      • Raw grades
      • Grade sets
      • Other relevant data

Coming soon:

  • Staff data:
      • Personal data
      • Contract information
      • Absences
  • Exam results
      • Raw grades
      • Other relevant data
  • Aggregate data sets (e.g. percentage attendance for today, total students)
  • National Ofsted data sets


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.

We first need to assess the quality of your Arbor data before we input it into Power BI. Our Product Team will arrange this before you purchase the Connector, and we’ll let you know if you need to take any action to sort your data. 

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) get in touch with our Support Team.
  • If you have any queries about how Microsoft Power BI works, please contact the Microsoft Power BI Community.

Please allow a maximum of four weeks to set up your Connector.


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.

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



Please sign in to leave a comment.