In this article, we will try to objectively understand the differences between the Power BI Personal vs On-Premises Data Gateway and understand their coexistence.
First, let us check the side by side comparison of these two types of gateways and their use cases.
Table of Contents
The data gateway is an application that runs an encrypted REST endpoint from your local machine or a server. The primary job of the gateway is to facilitate access to data that is stored on a private, on-premises network, that enables you to use that data in cloud services like Power BI and other Azure services like Flow, Logic Apps, etc. See the screenshot below:
Some of the online data sources like Azure SQL, Azure SQL Datawarehouse does not need a gateway. PowerBI can directly communicate with these PAAS Databases and have their own data refresh frequencies.
Now, let us look at some of the highlights of these two types of gateways:
Users and data analysts can install the Power BI Gateway—Personal to refresh supported on-premises data sources. The gateway software is only available in 64-bit. There is no separate software for Personal or Enterprise. The user will have to select which Gateway type is needed. For non-administrator users, you will not be able to install the On-premises Gateway (Enterprise).
Certain scenarios cannot be scheduled for data refresh:
This type of gateway is designed for a centralized IT team to manage. IT can install the On-Premises Data Gateway to serve large groups of users to refresh supported on-premises data sources. It was previously known as the Power BI Gateway—Enterprise. The additional functionality that this gateway type allows is as follows:
We hope that this information helped understand the differences between the Power BI Personal vs On-Premises Data Gateway in more details. Questions or suggestions are welcome in the comments section below. Thanks for visiting!
On-premises data gateway (personal mode)
Comments are closed.