This article details the following in relation to OData
- How to get data from the Bromcom MIS into Power BI using OData.
- How to publish Power BI reports and charts to the MIS
OData can be used with any software allowing an OData connection, for example, Excel.
Access: The minimum permissions required to use the OData Feed are found in the Reporting Module of Config>Setup>Roles & Permissions.
Prequisites:
- A Power BI Pro account;
- Power BI desktop already installed (as installation is not covered in this guide); and
- One Stop Shop licence.
Query the Data
The first step after downloading and installing Power BI Desktop is to get the data.
Click the Get Data Dropdown on the Home tab and select OData Feed.
URL, Username and Password
You will be prompted to provide a URL for the feed.
Enter https://misodata.bromcom.com/
Click Ok
Select Basic from the tab on the left and provide the following credentials:
User name : this is the five digit Site ID
Password : this is the User Access Key
User name: This is the five digit site ID, this can be found by clicking the dropdown arrow on the top-right of Bromcom,
The example below is for illustration purposes only, the site ID will be different for each school.
Password: This is the User Access Key. To generate and access the User Access Key click the My Account menu in the top right-hand corner of the MIS, then scroll down to the General panel, User Access Key
If the field is grey simply click the refresh button
Once the User name and Password have been entered click Connect
Filter and Transform the Data Before Loading
You will see a preview of the MIS data tables in the Navigator pop up. Select the tables you want to import by selecting these from the list on the left hand.
Important: you must select only a handful of tables to load into BI at any one time. If you select too many tables the volume of data will be too large and it is likely the import will fail.
When you are ready to load the tables, select Load.
Tip: With larger datasets, e.g. Attendance, use the Transform Data button to format the data at this point via the Query Editor, to ensure the volume of data is small enough to load. From the Query Editor you can apply various filters, eg filtering to the current academic year.
The data might take a few moments to load. Once its finished your query will now be stored in the BI dashboard ready to manipulate and start creating visualisations.
