API access to Insight tables for Power BI
Data in Insight table reports can be pulled into other systems, such as Microsoft Power BI.
To do this, an Insight user with Admin permission must first create an API Key. An API key is then used when accessing Insight data from other systems.
Create an API Key
In Insight, go to Account > Admin > API keys
Click Create API Key.
Choose if the API key should be able to access pupil details (names, etc). If not, then you'll get anonymised pupil records instead.
Click Create API Key.
The created API key is displayed. Copy the key and save it somewhere secure.
Create a Table Report
Go to Reports > Tables. Set up a new table, or open an existing one.
Click Download > Live Link.
Choose a data format (Excel is the simplest to get work with).
Click Copy URL. This is the URL you'll use in your other system when requesting data.
Connecting from Power BI
As an example, here is how to get the Insight table into Power BI.
In Power BI create a new report.
Click Get data > Web.
Paste in the URL you copied from Insight's table report. Click OK.
Then, in the Access Web Content window, click Basic.
Leave user name blank. In password, paste in the API key you created previously.
Click Connect.
Use the Navigator window to select the table, then click Load.
Now use Power BI to build a report using the data from Insight.
