Information Services

Menu

Power BI Gateway for CAHSS

A new project that will oversee the adoption of the centrally supported Power BI Gateway component within CAHSS has recently got under way

The project HSS019 has started and will oversee the adoption of the centrally supported Power BI Gateway component within CAHSS.  In particular, it will establish links and data feeds to provide an interface to the College:

  • School and Programme Quality System (SPQS)
  • Inventory System

The Power BI Gateway is required to securely handle data connectivity and data transfer between on-premise data and Cloud services. The gateway is required initially for the following Power BI activities in CAHSS;

  • Scheduled data refresh for on-premise datasets imported to the Power BI Service
  • Use of DirectQuery to query data from the Power BI Service
  • Use of Analysis Services, Live Connections, to query data from the Power BI Service

Once implemented, this service will be fully supported as production service and would be made available across the university.