Versions Compared

Old Version 3

changes.mady.by.user Richard Goerwitz

Saved on

compared with

New Version Current

changes.mady.by.user Richard Goerwitz

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Power BI

Power BI is a Microsoft business analytics service, available generally as part of Office 365.  It can be run from a local on-premises server or from the cloud.  It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or, worse yet, database administrators to create these reports and dashboards.

...

Carleton, as of 2018, uses the cloud-based offering, and reports/dashboards are accessed generally at http://app.powerbi.com/.  Grade reports (which were the first broad Power BI-based campus offering) are available here.

Power BI reports and dashboards are created either online via the web interface (link above) or, better yet, through Power BI Desktop and deployed to the cloud.

Licensing

Power BI Desktop, the app, is free.  But using Power BI in the cloud is not free.  It requires a license, which is autoprovisioned into Office 365 (as of May 2020) by FIM.  If users need Power BI licenses or ask for them, they are almost certainly asking for this.  Assign tickets to whoever is currently managing FIM (Les as of 2020), or to Richard.  The relevant FIM sets to manage here are as follows:

Image Added

Gateways

Power BI reports, even though cloud hosted, can interact with data sources inside Carleton's network.  This is done via the On-premises Power BI Gateway service (named as such in the MS Windows services GUI; actual name is PBIEgwService).  This service is running (as of June 2018) clustered on two servers,

There is an On-premises Data Gateway app on both of the above servers that may be used to check versions numbers, start/stop the service, and (temporarily) up the logging level.

...

  • Lack of internet connectivity
  • Current non-Faculty status (i.e., not included in AD Faculty group; see Les about this)
  • No grades available (e.g., new faculty member)
  • Unable to authenticate using Carleton's SAML provider (same issues as other logins - CHECK THIS FIRST)
  • Not licensed for Power BI (Helpdesk can't make this determination; assign to Richard Goerwitz; or go to Sande Nissen or Dave FlynnDan Stephans)
  • /wiki/spaces/itskb/pages/26119351 is down on /wiki/spaces/itskb/pages/26139125 (Helpdesk can't make this determination; assign to Richard Goerwitz; or go to Dave FlynnDan Stephans)
  • Gateway to data warehouse is down (Helpdesk can't make this determination; assign to Richard Goerwitz; or go to Dave FlynnDan Stephans)

Richard Goerwitz
Created:  2018-06-16