Power BI gateway

The Power BI data gateway is software that you intall on the SQL Server hosting the Pims Database. The gateway facilitates access to the data from Pims to the Power BI environment. See Microsoft's documentation here and here for more information on installing the gateway on the SQL Server.

When installing the gateway software you need to authentication againts the Power BI environment that will host the gateway. If the Power BI environment is owned by the Pims client the client needs to provide the credentials.

Pims Power BI Gateway User Credentials

Create a user and role with access to the Pims data that is going to be used by the Power BI reports, dashboard etc

  • Create a dedicated Pims Role and provide the Pims data access necessary to access the data users needs to create reports, dashboards etc.
  • Create a dedicated Pims User and add it as a member to the Pims Power BI Role

Configure the Power BI gateway

After the installation the gateway will be added to the Power BI environment and will be configured through Power BI Admin Center. The administrator needs to add a Data Source to the gateway, one per Pims database if multiple. Provide the Power BI administrator with: Server name, Database name and Pims database credentials (described below) to be used with Basic Authentication Metode.

Power BI Gateway usage

In order for a Power BI dataset to use by the gateway after the a report is published, its important that the user developing the report uses the same Server and Database name as specified in the gateway configuration.

For more information on how to create a dataset which uses the gateway see Microsoft's documentation here