Skip to content
Related Articles

Related Articles

Data Gateways in Power BI

View Discussion
Improve Article
Save Article
  • Last Updated : 25 Feb, 2021

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 GatewayOn-Premises Gateway
Target PersonsIndividuals who wish to generate their own report.BI administrators who wish to develop the gateway for the organizations’ use.
UsageAnalystBI Administrator and Developers
MonitoringNo monitoringThe organization can monitor the accounts.
Services SupportedOnly Power BIPower BI, PowerApps, Microsoft Flow, Azure Logic Apps
My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!