Setup on-premises data gateway

In this post i am going to list out all the things I had to do setup an on-premises data gateway. It can be setup either in personal mode or standard mode. I am going to set it up in standard mode which is recommended by Microsoft for high availability. Personal mode is more suitable for testing.

What is on-premises Data gateway:

On-Premises data gateway is nothing but a software running on a server. It acts like a secure pipeline to transfer data between on-premises data and Microsoft cloud(Power BI, PowerApps, Power Automate, Azure logic apps etc). It should be setup on a machine part of on-premises network and should be reachable to all data sources on-premises, which you are looking to connect with Microsoft cloud services.

Server Requirements:

Minimum requirements:

  • .NET Framework 4.6 (Gateway release August 2019 and earlier)
  • .NET Framework 4.7.2 (Gateway release September 2019 and later)
  • A 64-bit version of Windows 8 or a 64-bit version of Windows Server 2012 R2

Recommended:

  • An 8-core CPU
  • 8 GB of memory
  • A 64-bit version of Windows Server 2012 R2 or later
  • Solid state drive (SSD) storage for spooling.

Server requirements are from Microsoft article https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install

Note: Gateways aren’t supported on server core installations & domain controller machines. It should be configured on an on-premise server for obvious reasons.

You can configure gateway independently or as a cluster. We have the option to start with one and add more servers to make it a cluster.

Network needs:

Before we jump to installation section, we have to make sure that below listed FQDNs & ports are accessible from on-premises data gateway server. Only if these are open and accessible, we can move forward with installation and registration.

FQDN Outbound ports Description
*.download.microsoft.com 80 HTTP used to download the installer.
*.powerbi.com, *.analysis.windows.net, *.login.windows.net, *.frontend.clouddatahub.net, *.core.windows.net, login.microsoftonline.com, *.msftncsi.com, *.microsoftonline-p.com 443 HTTPS
*.servicebus.windows.net 5671-5672; 443, 9350-9354 Advanced Message Queuing Protocol (AMQP); Listeners on Service Bus Relay over TCP

 

Installation:
  • Installation steps are easy and straight forward. Download and run the installer. 
  • Installation continues if there is no gateway already running on the machine. Click Next.
  • Select On-premises data gateway.
  • Leave the default path, Select Install
  • Enter Office365 work email to Sign in to register your gateway.
  • Select Register new gateway if you are setting it up new.
  • Enter gateway name, recovery key.
  • If configured properly you should see Status with Ready tick mark for PowerApps, Microsoft Flow & Power BI.
  • If you plan on using gateway to connect data with Logic Apps & Azure analysis services, you need to setup additional gateway component in your Azure subscription and connect gateway with that.

After gateway is setup, you have the option to run network ports diagnostics test to make sure all the required ports are accessible.

Option to restart the gateway is available under Service settings tab. It is suggested to restart the gateway whenever any changes to settings are made or gateway updated to new version.

Note: Unless you want to change, gateway service will be running under a service account NT SERVICE\PBIEgwService