Note: All pages shown below are subject to having relevant Roles and Permissions.

Prerequisites;

• A Vision license
• A Power BI Pro Account

In this guide we will cover the following aspects of using Power BI with Vision;

• Licensing Requirements 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 (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 Vision Analytics Pack or share reports they have created with others.

The Vision License for the oData Feed can be purchased separately if you are not a One Stop Shop customer.

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 to setup Vision users with restricted access. But Setting up restricted user accounts in Vision IS a prerequisite for restricted access to Vision Analytics Pack (Power BI).

Within 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 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 Vision Analytics Pack, or any of the Trust’s bespoke Power BI reports can be viewed within Vision using Reporting>Power BI Viewer. Doing this means that the Vision user does not have to log into another service to see the Power BI reports.

Ideally, your School will have a 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 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 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 Vision (one for each school).