The on-premises data gateway, or simply data gateway, is a piece of software that's installed on an on-premises computer that provides a secure connection between local, on-premises data and a variety of services that reside in Microsoft's Azure cloud, including the Power BI Service. Once installed, the Service can use this gateway to refresh datasets that have been published to the Power BI Service, as shown in the following screenshot:
Figure 1 – Data Gateway
There are two modes in which the gateway can operate, as follows:
- Standard (previously called Enterprise)
- Personal
The reason we install a gateway in one mode versus the other comes down to the scenario in which you plan to use the gateway. You would want to use the Standard (Enterprise) mode if the following applies:
- You wish to use the gateway for ...