Azure Power BI Gateway

• User needs: Governance and Connectivity

• User profiles: Business Users, Data Analysts

• User assumed knowledge: None

Azure Power BI Gateway (Standard mode) is a service that keep your Power BI dashboards and reports up to date by connecting to your isolated Cloud data sources without the need to move the data.

DSL admin users of EC DataPlatform have access to a shared Power BI Gateway. These users can allow other DSL users to access this shared Power BI Gateway to establish connections between the Power BI Gateway and their deployed resources in EC Data Platform. These connections allow DSL users to access their datasets outside the private subnet of EC Data Platform.

For example, DSL users can establish connections between the Power BI Gateway and their deployed SQL database servers. Once these connections are in place, the users are able to connect to their datasets hosted in the SQL database servers outside the private subnet of EC Data Platform, i.e., continue analyzing their Power BI datasets on their local computer.

We provide user instructions on how DSL admins can provide other DSL users access to the EC Data Platform Power BI Gateway. Also, we provide user instructions on how to establish Power BI Gateway connection to:

• SQL Database server.

Finally, we provide user instructions on how to set-up a scheduled refresh of a dataset, so that the dataset can be refreshed via the Power BI Gateway connection.

Provide DSL users access to the Power BI Gateway

To provide DSL users access to the Power BI Gateway as DSL admins,

Step 1. Go to the webapp of Power BI using a local internet browser: https://app.powerbi.com/. Log in using your EC Data Platform account and provide your password.

Step 2. On the top-right of the page click on "Settings" and click on "Manage gateways".

Step 3. Here, you should see a Power BI Gateway named "ECDP PBG VM". If not, please contact the technical team of EC Data Platform. Click on "ECDP PBG VM" Power BI Gateway and click on the "Administrator" Tab.

Step 4. Provide the EC Data Platform user that need access to the Power BI Gateway, and click on "Add".

Creating Power BI Gateway connection with SQL Database server

To establish a Power Bi Gateway connection with your SQL Database server,

Step 1. Go to the webapp of Power BI using a local internet browser: https://app.powerbi.com/. Log in using your EC Data Platform account and provide your password.

Step 2. On the top-right of the page click on "Settings" and click on "Manage gateways".

Step 3. Here, you should see a Power BI Gateway named "ECDP PBG VM". If not, please contact your DSL administrator or the EC Data Platform technical team to provide you access. Click on the "three dots" and click on "Add data source".

Step 4. Provide a name for your data source connection and choose "SQL Server" as Data Source Type. Then, provide the full server name of the SQL Server and the Database you want to connect to. To continue, select "Basic" as Authentication Method.

Step 5. Provide the admin username and password of your SQL Server provided to you at the DSL deployment. Click on "Add" to finish.

Creating a scheduled refresh of a dataset hosted in EC Data Platform

To create a scheduled refresh of your dataset hosted in EC Data Platform using the established Power Bi Gateway connection,

Step 1. Go to the webapp of Power BI using a local internet browser: https://app.powerbi.com/. Log in using your EC Data Platform account and provide your password.

Step 2. Navigate to the dataset which a scheduled refresh need to be set up. Click on this dataset.

Step 3. Click on "Refresh" and click on "Schedule refresh".

Step 4. Click on "Gateway connection". Here you will see the Power BI Gateway connections you have previously established. Select the connection to the data source of your dataset and click on "Apply".

Step 5. Navigate back to the dataset and click on "Refresh now" to test whether you can the Power BI Gateway connection can refresh your dataset hosted in EC Data Platform.