Installation Guide

Data Gateway Installation

Prerequisites

  • .NET Framework 4.7.2
  • A 64-bit version of Windows 8 or later or a 64-bit version of Windows Server 2012 R2 or later
  • See list of required ports at the bottom of this page.

Installation Process

In Power BI console https://app.powerbi.com/home .

Click the down arrow on the top right of the page and select Data Gateway.

You will be taken to https://powerbi.microsoft.com/en-us/gateway/ Click DOWNLOAD GATEWAY.

Once the download has completed copy the PowerBIGatewayInstaller.exe file to your SCCM server and click on it begin the install process.

Note: You will need local admin rights on the SCCM server to perform the installation.

Select On-premises data gateway (recommended) and click Next.

Accept the terms of use and privacy statement and click Install.

Once the installation has been completed you will be prompted for an email address to use with the gateway. Enter your corporate email address and click Sign in.

Note: You may be prompted to sign into Azure. If so, sign in again using the same email address.

Enter a Name for the data gateway and create a Recovery key.

Store the recovery key in a safe place.

Click Configure.

You should see a notification that your gateway is now online and ready to be used.

Here you can Click Close; unless your organization utilizes a user authentication based proxy server to access the internet in which case please see Appendix E - Change the on-premises data gateway service account.

Data Gateway required ports

The gateway creates an outbound connection to Azure Service Bus. It communicates on outbound ports: TCP 443 (default), 5671, 5672, 9350 through 9354. The gateway does not require inbound ports.

It is recommended that you add the IP addresses to an allow list, for your data region, in your firewall. You can download the Microsoft Azure Datacenter IP list, which is updated weekly. Alternatively you can obtain the list of required ports by performing the Network port test on the on-premises data gateway application. The gateway will communicate with Azure Service Bus using the IP address along with the fully qualified domain name (FQDN). If you are forcing the gateway to communicate using HTTPS it will strictly use FQDN only, and no communication will happen using IP addresses.

Note: The IP Addresses listed in the Azure Datacenter IP list are in CIDR notation. For example, 10.0.0.0/24 does not mean 10.0.0.0 through 10.0.0.24. Learn more about the CIDR notation.

Here is a listing of the fully qualified domain names used by the gateway: