Use this form to request access to Power BI Gateway Service. Texas State University manages a gateway for access to on-premises data sources that may be used in the Microsoft 365 Power Platform (ex: Power BI, Power Automate, etc.)
Staff and Faculty may request specific data sources to be added.
Data Source
A data source is the specific connection to an on-premise data source such as connection to a specific database on a SQL server.
Ex. SQL Server x.txstate.edu, using service account sa-serviceaccount@txstate.edu.
The requestor is responsible for working with the information owner (Ex. Owner of the records/resource you’re querying) to grant access to a service account created by Technology Resources.
Service accounts in this case should only be granted access to the data that is needs access to. For instance, full read access to a database is not recommended. Instead, use a per-table grant system or only access to a view that has the fields necessary for data collection.
Request Process
- Information Security Office - Review - ISO will review the request and offer up any mitigations prior to creation of the data source.
- Technology Resources - Service Account Creation - A service account will be created for use by the data source
- Requester - Access Request - The requestor of the data source will work with the Information Owner to grant the required access to the on-premises data source.
- Technology Resources - Data Source Creation - Once the service account has the appropriate access, a data source will be created and given access to the requestor.