Overview Of Data Gateway In Power BI

Overview

In this article, we will discuss the following.

  1. Definition of Gateway
  2. Prerequisites to Configure Power BI Gateway
  3. Important Points before we start Installation of Data Gateway
  4. Two Modes of Gateway Installation
    1. Personal Mode
    2. Recommended Mode (Enterprise Mode)
  5. Difference between Personal Mode and Recommended Mode

What do we mean by Data Gateway?

  • A Gateway is a software which will provide a facility to connect our on-premise data sources (like SQL Server, SharePoint and many more) with online services like Power BI.
  • A gateway acts as a Gatekeeper.
  • Gateway listens to requests from client and grant access only if authentication is successful.
  • A gateway uses encryption to store sensitive information like passwords.
  • A gateway will encrypt and compress all the data to pass through it.

Prerequisites to Configure Power BI Gateway

Before we start the installation of Power BI Gateway, we need to consider the following prerequisites.

Minimum System Requirements

.Net FrameworkMinimum 4.5
Operating System64 – bit Windows 7 / Windows Server 2008 R2 or later

Recommended System Requirements

CPU8 Core
RAM8 GB
Operating System64 -bit Windows Server 2008 R2 or later

Important Points before we Start Gateway Installation

  • It is not feasible to install Gateway on Domain Controller machine.
  • We cannot install a gateway on a computer, such a laptop, that may be turned off, asleep, or not connected to the internet.
  • We can install a gateway on 64- bit machine only.
  • We can install up to two on-premise gateway in a single machine. (One for Personal Mode and one for Recommended Mode)
  • We cannot install more than one gateway running on the same mode on the same commuter.

Ex

We cannot install two Personal mode gateways on a single machine or we cannot install two Recommended mode gateways on a single machine.

  • For Personal mode, we can install and configure one on-premise gateway for one Power BI user.

Ex

If I have installed one gateway with Personal Mode on Machine 1 with user “Jack", now, if I install gateway with Personal Mode on Machine 2 with same user “Jack”, it will not be allowed or it will take the most recent installation setting of machine 2.

  • For Recommended mode, we can configure more than one on-premise gateways with a single user. We can manage all the gateways using Power BI Online Services.

Two Modes of Gateway Installation

Power BI provides two modes of Gateway when we install Gateway.

  1. Personal Mode
  2. Recommended Mode

Now let’s elaborate on each term in detail.

Personal Mode

Let’s take a real-life scenario. Suppose you have a large Excel file, One SQL SERVER database, and one Oracle database. You are the only one who is responsible to use data source and prepare Power BI report. You don’t want to share this thing with anyone other in an organization. At that time, you can go with the Personal Mode.

  • Allow single user to connect to the data source
  • Sharing of Data source is not allowed.
  • Can be used with Power BI Online.

Recommended Mode

Let’s take a real-life scenario. Suppose you have different data sources, like Large Excel file, SQL Server, and Oracle data source. Now, you want to share the same data source with all your vendors, people from an organization. At that time, you can go with Recommended or Enterprise Mode.

  • Allow multiple users to connect to the data source.
  • Can be used with – Power BI, Power Apps, Flow and Azure Logic Apps.

Difference between Personal Mode and Recommended Mode for Gateway Installation

Now, let’s check the difference between Personal Mode and Enterprise (Recommended) Mode.

Personal ModeEnterprise (Recommended) Mode
Sharing is not allowedSharing is allowed
Best for single userBest when you want to share data source with Organization
Only use with Power BIWe can use it with – Power BI, Power Apps, Flow, Azure Logic

Conclusion

This is how we can get started with Data Gateway in Power BI. In my next articles, we will talk about the installation process of Data Gateway with Personal Mode and Recommended Mode.

Up Next
    Ebook Download
    View all
    Learn
    View all