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


  • 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

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
* 80 HTTP used to download the installer.
*, *, *, *, *,, *, * 443 HTTPS
* 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.

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

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Disable feedback surveys in Power Platform

If you have worked in Microsoft 365 PowerApps or Power Automate, you might be familiar with feedback survey which pops up quite often. Microsoft wants your feedback on how likely are your to recommend Power Automate to a friend or colleague? Well, I ran into a conversation in twitter about this survey. Apparently I learnt […]

Read More

Missing Office upload center

Couldn’t find annoying Microsoft upload center anymore in your Windows machine? Good news! It is gone forever. Microsoft replaced the upload center with ‘Files Needing Attention’ experience in Office applications. What is Microsoft upload center It is the application that deals with office file uploads to cloud services like SharePoint online, OneDrive for Business and […]

Read More

Step by step guide to configure Viva Connections

Update 09/23/2021 – Viva Connections public preview is available now. Steps defined in this article to create an LOB Teams application using PowerShell is not necessary now. Viva Connections app is available in Teams admin center. This new app replaces Step#3 & Step#4 in this article. You still has to go through the home site […]

Read More