Page Comparison

A Power BI gateway is a piece of management software that runs on an Azure virtual machine (VM) and is used as a management software for controlling access on the Power BI platform to various data sources, and enables . Power BI gateways enable departments/teams to publish reports and to refresh data in reports that they developcreate.

The IT Analytics team is implementing the Power BI gateways as part of an enterprise-wide solution , that will allow departments and non-Analytics other IT teams can to use this software as a service, instead of having . The main benefit of this solution is that individual departments/teams will not need to invest in setting up their own a reporting infrastructure.

If your department/team is interested in having a gateway set up, please follow these directionsthe instructions below:

1. Request IT-Security to create a Service Account(s)

   1. Submit a request for a service account

   to

   1. for each data source

   (like Banner PROD, DWHOUSE, FAST, GEMS etc.)Once the account is created and you have the user name and password, please

   1. your department/team will need to create Power BI reports.

      1. To submit a request for a service account in the Data Warehouse (DWHOUSE), please use the following link: https://usfpro1.forest.usf.edu/pls/ax_dwhouse/f?p=1057:502. All requests for DWHOUSE accounts go through an approval process. The approvals needed will depend upon the Data Access Level (DAL) security you request. To learn more, please read Understanding DAL Security.

      2. To submit a request for a service account in one of the other business systems (e.g., Banner [PROD], FAST [FASTPRO], GEMS [GEMSPRO], etc.), please send an email to IT-Security@usf.edu requesting a service account be created for each data source needed.

2. Request a Power BI Gateway

   1. Once your service account(s) have been created for your data sources and you have received the service account name and password for all requested data sources, please send a request for a Power BI gateway to the IT Analytics team. To do this, either send an email to IT-Analytics@usf.edu or submit a HELP ticket to the

   Analytics team (

   1. Service Team “Analytics” in Jira

   : Analytics), which we will then prioritize and contact the respective department/team

   1. .

   2. After your request has been received, it will be prioritized along with other requests. You will be contacted to set up a meeting

   and

   1. to configure

   the

   1. your new gateway.

   During the meeting while the gateway is being set up, you will be required to enter

3. Setup Your Power BI Gateway

   1. You will need the password for each data source available during your meeting with the IT Analytics Team representative to set up your Power BI gateway.

   We will

   1.  

   2. Once your Power BI gateway has been set up, a couple of people

   from the department as the admins of the gateway, and going forward the admins can add members from their

   1. in your department/team will be added as gateway administrators. The gateway administrators will have the ability to add members from your department/team as report developers.