Installing and using data gateways
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 Power BI service can use this gateway to refresh datasets that have been published to the Power BI service, as shown in the following diagram:
Figure 11.1 – Data gateway
There are two ways the gateway can operate, as follows:
- Standard
- Personal
The reason to install a gateway in one mode versus the other comes down to the scenario in which you plan to use the gateway. You will want to use the standard mode if the following applies:
- You want other users within the organization to use a single, centralized gateway.
- You need DirectQuery, as well as import mode datasets.
- You wish...
