Versions Compared

Old Version 1

changes.mady.by.user Richard Goerwitz

Saved on

compared with

New Version 2

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.

Power BI reports and dashboards are available from any major browser on any major internet-connected platform (Windows, OS/X, Android, etc.).  There is also an IOS and Android Power BI app.

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, 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 , running is PBIEgwService).  This service is running (as of June 2018) clustered on two servers,

  • SQLSERVER1-2016.ads.carleton.edu (master)
  • DWSQL-2016.ads.carleton.edu (slave/secondary)

 

 

Platform

Grade reports are delivered using Microsoft Power BI, a cloud-based analytics platform available generally as part of Office 365.

Locations Available

Grade reports are available from any major browser on any major internet-connected platform (Windows, OS/X, Android, etc.).  There is also an IOS and Android Power BI app.

Where can I get help?

Submit 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.

Either server may go down or be upgraded without affecting service.  Documentation on adding/dropping members from the above cluster is available from Microsoft:  https://docs.microsoft.com/en-us/power-bi/service-gateway-high-availability-clusters.

User Help

Users needing help should submit requests for help to the help desk, and tag the requests as data warehouse requests.

...

  • Lack of internet connectivity
  • Current non-Faculty status (i.e., not included in AD Faculty group)
  • 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 Matthew Lauterbach; or go to Sande Nissen or Dave Flynn)
  • /wiki/spaces/itskb/pages/26119351 is down on /wiki/spaces/itskb/pages/26139125 (Helpdesk can't make this determination; assign to Richard Goerwitz or Matthew Lauterbach; or go to Dave Flynn)
  • Gateway to data warehouse on /wiki/spaces/itskb/pages/26133288 is down (Helpdesk can't make this determination; assign to Richard Goerwitz or Matthew Lauterbach; or go to Dave Flynn)

Richard Goerwitz
Created:  2017 2018-0406-25 16