Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. Power BI performs functions of data sourcing and preparation, data analysis and data visualization.
Power BI includes:
- “Power BI Service” the SaaS (software as a service) based online service used for consuming and publishing reports and dashboards.
- “Power BI Desktop” the Windows-desktop-based application for PCs and desktops, primarily for designing and publishing reports to the Service.
See Service Catalogue entries Admissions Dashboards, Enrollment Dashboards and Enrollment Planning Management for more information on ITS Analytic Solutions including how to request access.
Power BI is available 24/7 except during scheduled maintenance and unplanned outages.
There is no request procedure for Power BI “Free” or Desktop. You can access Power BI through Office 365. For Power BI Desktop installation instructions, please refer to Installing Power BI Desktop on the ITS Training & Support Centre SharePoint site.
To get a Power BI Pro license, submit an additional access request via the Security Access Request Form (SARF). Expand the “Office 365 Services” section and select the Power BI Pro license option.
There is no charge for Power BI Service or Desktop.
Power BI Pro is the fully downloaded/installed product that can be requested at an additional license fee.
Please scroll to the bottom of this page for all frequently asked questions about this service.
Power BI Desktop is a free desktop application that can be installed directly onto your own computer. It works cohesively with Power BI services to provide advanced date exploration, shaping, modeling, and report creation with highly interactive visualizations. Work done on Power BI desktop can be saved as a file and published directly onto your Power BI site to share with others. For installation instructions, please refer to Installing Power BI Desktop on the ITS Training & Support Centre SharePoint site.
Power BI Pro is an individual user license that allows access to all content and capabilities in the Power BI service. This does not mean that you by-pass security, you will still need to be given access to the appropriate workspaces and apps. With Power BI Pro, you can share content and collaborate with other Pro users. Only Pro users can publish content to other workspaces, share dashboards, and subscribe to dashboards and reports. See Power BI Pro | Microsoft Power Platform for more information.
A Power BI Pro license is required if you wish to share reports that you create in Power BI Desktop, or in the Power BI Service (website). It is important to note that everyone you share your report with also require a Power BI Pro License.
To get a Power BI Pro license, submit an additional access request via the Security Access Request Form (SARF). Expand the “Office 365 Services” section and select the Power BI Pro license option. Please see Security Access Request Form (SARF) (sharepoint.com) for more information.
Yes, Power BI apps are available for Android, iOS, and Windows 10 devices and can be downloaded in your app store.
Currently, the two main ITS-created apps are for Admissions and Enrolment. To get access to these apps, submit a Security Access Request Form (SARF) to request assignment to the appropriate role. These are under the “Power BI Access (Dashboards)” section of the SARF form, titled: “Admission – general Access” and “Enrolment – general access”.
There are a few ways to share reports you have created with others:
- If both you and the person you are wanting to share with have Pro licenses, you can share the report with them by using the share feature.
- If you don’t have Pro licenses, you can export the data to excel, or to PDF / PowerPoint.
- If you have a Workspace that is on the Power PI Premium Capacity, you can share the App or Report directly with ANY end user, regardless of their licensing arrangement.
If you open a Power BI dataset, there is an option along the top bar that says, “Analyze in Excel”. This will allow you to directly connect to the Dataset in Power BI from Excel.
First, open the workspace where the content is located. Along the top row under “Update / Create App”, you will see a horizontal list. By default, you’ll see View, Filters, Setting, and Access. If you click view, you can see the option to change to Lineage. This will show you the flow from the data source, to the dataset, to the reports.
If you hover on the report/dataset/workbook in the workspace view, click the vertical ellipsis (three vertical dots). At the bottom you will see manage permissions. This will show you who (or what role) has access to the content.
To embed a report in Power BI, navigate to the report you want to embed. Along the top bar, click on File > Embed Report, and choose where you want to embed the report. If you do not see ‘embed report’, you do not have the appropriate elevated permissions to the report. Embedding a report to ‘SharePoint online’ or ‘Website or Portal’ will embed a version of the report that respects all row-level and object-level security. This also implies that to see the embedded report, the user must already have access to the report. When you select ‘Publish to web’, you will be embedding a report with no permissions. This means that anyone who has access to the place in which you embed the report will have access to see the report.