On-premises data gateway versus personal mode

The first configuration setting when installing a gateway is the mode of the gateway, as depicted in the following image:

On-premises data gateway installer

The default and recommended gateway mode (commonly referred to as the enterprise mode) provides all the functionality of the personal mode plus many more features and management capabilities. These additional benefits include support for DirectQuery and Live connection datasets, several other Azure services, such as MS Flow, and the management capabilities described in the Managing gateway clusters section later in this chapter.

A single ...

Get Mastering Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.