Open In App

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy

Data Gateways in Power BI

Prerequisite – Power BI

The main goal of power BI is to build the dashboard and to keep the data up to date and make sure that the data is continuously fetched at every instance of time in order to track the changes at every instance of time.
We can integrate our Power BI to several databases like –



  1. File
  2. Database
  3. Power Platform
  4. Azure

We need a gateway to connect to the Power BI services up to the Data Sources, and we can do it using 2 gateways –

  1. Personal Gateway
  2. On-Premises Data Gateway

Personal Gateway :
It is used for personal usage and does not require any organization’s credentials to connect to the database. Anyone can set up the personal gateway and use it to refresh the data, configure the data and install it on a personal machine.



Key Features of Personal Gateway –

  1. Works Only with power BI cloud services.
  2. Import data and set up scheduled refresh from the given data sources.
  3. Runs as an application for the users who are not administrators of the computer.
  4. Runs as a single user using only your login credentials.

How to get Power BI Personal Gateway?

  1. Click on the “Download Icons” in the top right corner.
  2. Click on the “Data Gateway” from the drop-down menu.
  3. You will see the different type of gateways on the Power BI page, which gets open on the new tab.
  4. You can click on the “Download Gateway” option to download it.
  5. Select “Personal Gateway” and carry on with further installation.
  6. After installation, we can connect to the database services using the windows authentication method.
     

On-Premise Data Gateway :
It is a paid service mostly used with an organization’s credentials to connect to the database. Users should be from the same organization to set up the gateway and work on it.

Key Features of Personal Gateway –

  1. Works with power BI cloud services, PowerApps, Azure Logic Apps, Microsoft Flow.
  2. Import data and set up scheduled refresh from the given data sources.
  3. Provides access to multiple users along with the access control per data source.
  4. Support for direct Query to SQL Server.
  5. Monitoring and auditing the services.

How to get Power BI Enterprise Gateway?

  1. Click on the “Download Icons” in the top right corner.
  2. Click on the “Data Gateway” from the drop-down menu.
  3. You will see the different type of gateways on the Power BI page, which gets open on the new tab.
  4. You can click on the “Download Gateway” option to download it.
  5. Select “Enterprise Gateway” and carry on with the further installation.
  6. While signing in, enter the Email ID when prompted and insert the same email id which you had used to log in to the Power BI account.
  7. This would become an admin for the gateway.
  8. You can add other admin accounts later.
  9. In order to configure the gateway insert the gateway name, recovery key and click on finish.
     

Comparative study of Personal and On-premises Gateway :

  Personal Gateway On-Premises Gateway
Target Persons Individuals who wish to generate their own report. BI administrators who wish to develop the gateway for the organizations’ use.
Usage Analyst BI Administrator and Developers
Monitoring No monitoring The organization can monitor the accounts.
Services Supported Only Power BI Power BI, PowerApps, Microsoft Flow, Azure Logic Apps
Article Tags :
DBMS
SQL
Recommended Articles
1. Amazon Web Services - Introduction to NAT Gateways
2. PLSQL | POWER Function
3. POWER() Function in MySQL
4. POWER(), SUM() and PI() Function in MariaDB
5. POWER() Function in SQL Server
6. Power Center components in Informatica
7. Infosys Interview Experience for Power Programmer 2021
8. How To Get Current Date in Power Query?
9. Types of Sources of Data in Data Mining
10. Characteristics of Biological Data (Genome Data Management)
11. Difference between Data Warehousing and Data Mining
12. Data Preprocessing in Data Mining
13. Difference between Data Warehouse and Data Mart
14. Data Mining: Data Warehouse Process
15. Data Mining: Data Attributes and Quality
16. Data Reduction in Data Mining
17. Data Transformation in Data Mining
18. Difference between Data Lake and Data Warehouse
19. Data Architecture Design and Data Management
20. Difference between Traditional data and Big data
21. Difference between Big Data and Data Analytics
22. Difference between Traditional Data Center and Software Defined Data Center
23. Difference between Data Security and Data Integrity
24. Difference between Data Redundancy and Data Inconsistency
25. How to Convert Data From SQL to C Data Types?