Home » Power BI » Power BI Personal vs On-Premises Data Gateway

Power BI Personal vs On-Premises Data Gateway

Personal vs Standard gateway

In this blog you will understand about Gateway and difference between Personal mode and On-premises data gateway( recommended/ standard).

What is Gateway?

Gateway is an application and it provides the connection between Power BI cloud services and the data source located on-premises.

Using gateway you can schedule refresh the datasets on cloud. You can installed this application on any servers in the local domain.

Gateway is required- If the data source is located on-premises, then you need a gateway. Means, any local files, whether they are on a virtual machine or your local desktop, will require a data gateway.

For example- If you are fetching data from SQL Server database located on your local domain server, then you need a gateway.

Gateway not required– for online or cloud-based data sources. For example- if you are getting data from CRM Online,  Azure SQL DB, Azure Blob Storage etc.,  you don’t need a gateway.

on-premises-data-gateway

Image source – docs.microsoft.com



Types of Power BI Gateway

  • Personal Mode
  • Standard Mode

On-premises data gateway (Personal mode)

Only you can use this, and you can use it only for scheduling refresh in Power BI and It can be used only with Power BI service.

It does not support PowerApps, Azure Logic Apps, Power Automate, Azure Analysis Services, dataflows.

On-premises data gateway(Recommended/ Standard)

This gateway can be used by multiple users that have access to the server onto which you install the gateway. It can be used for both scheduling refresh and live queries in Power BI.

You can also use it for Power BI, PowerApps, Azure Logic Apps, Power Automate, Azure Analysis Services, dataflows.



Personal mode Vs On-premises data gateway( recommended/ standard)

Features On-premises data gateway (personal gateway) On-premises data gateway (recommended/ standard)
Cloud services supported Power BI Only Power BI, PowerApps, Azure Logic Apps, Power Automate, Azure Analysis Services, dataflows
Import data and set up scheduled refresh Yes Yes
Runs As you for Windows authentication and as configured by you for other authentication types As configured by users who have access to the gateway
Can install only as computer admin No Yes
Serves multiple users with access control per data source (Power BI Service) No Yes
Connection Type Import Import, Direct Query, Live Connection
Support for a live connection to Analysis Services No Yes
Usage Analyst BI admin, Developer

Refer more Power BI Post – Power BI

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome.

Leave a Reply