Note: All pages shown below are subject to having relevant Roles and Permissions.
Prerequisites;
- A MAT Vision license
- A Power BI Pro Account
In this guide we will cover the following aspects of using Power BI with MAT Vision;
- Licensing Requirements (MAT Vision and Power BI)
- Sharing the Dashboards/Reports and how to handle Permissions
- Obtaining API Keys
See also: How to use Power BI with Vision and How to use oData with Bromcom.
Licensing Requirements (MAT Vision and Power BI)
A user with a non Pro Power BI account can create their own Reports using the OData feed.
However, a Power BI Pro account will be needed for users to download the MAT Vision Analytics Pack or share reports they have created with others.
The MAT Vision License for the oData Feed can be purchased separately if you are not a One Stop Shop customer.
MAT Vision would be used to view and access data across multiple Schools, so at least one of these accounts is required.
If you want each School to have a customised view of the Data, then one Power BI Pro account would be required per School.
Sharing the Dashboards/Reports and how to handle Permissions
One of the benefits of Power BI is that it allows for flexible access.
A Power BI account is not required for MATs to setup MAT Vision users with restricted access. But Setting up restricted user accounts in MAT Vision IS a prerequisite for restricted access to MAT Vision Analytics Pack (Power BI).
Within MAT Vision, you have the ability to restrict how much specific users can see.
To do this, you must have a Power BI Pro Account, and the user you want to restrict must have a regular Power BI Account.
You can then find that user within MAT Vision and select which Schools they have access to.
If a School were to only have one Power BI Pro account shared across all of its users, each of them will see the exact same settings.
The MAT Vision Analytics Pack, or any of the Trust’s bespoke Power BI reports can be viewed within MAT Vision using Reporting>Power BI Viewer. Doing this means that the MAT Vision user does not have to log into another service to see the Power BI reports.
Ideally, your School will have a MAT Vision and Power BI Lead, who will set-up the Power BI PRO account on behalf of the school (with the restricted access appropriate to the school).
The School administrator decides whether to either;
- Use a single shared account so that every MAT Vision user sees the same Power BI reports.
- Or individual accounts, then the Power BI reports can be customised on a school-by-school basis as described earlier.
To choose shared or individual go to Admin > Power BI Configuration
Once they have selected, they can go to Admin > Users from the side Menu.
This allows them to edit the account for specific users and determine which Schools they have access to.
Obtaining API Keys
An API key is required PER Power BI Pro account.
To obtain the API Key, the Vision Administrator will need to access the Microsoft Power BI Dashboard (Microsoft Website) and sign in with the School Microsoft Account.
For Schools who are using a shared account, the API Key would be the same for all.
If the Trust only needs one view of the Power BI dashboards, only one API Key is needed (from the admin user account).
For Schools where there are more than one Power BI Pro account, they would require separate API Keys. The Vision Administrator for the School would need to obtain these via MAT Vision.
If multiple restricted views of the Power BI reports are required for multiple schools, then an API Key is required from each of the restricted users that have been created in MAT Vision (one for each school).