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.
- .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
- 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.
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.
|*.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 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.
Note: Unless you want to change, gateway service will be running under a service account NT SERVICE\PBIEgwService