On Premises Data Gateway

Bonisiwe Shabane

-Dec 10, 2025, 7:49 PM

Keep your data in Power BI, PowerApps, Logic Apps, and Power Automate up to date using the on-premises data gateway Windows 10, Windows 11, Windows Server 2019, Windows Server 2022 Unlock the full potential of your on-premises data in Power BI by setting up an on-premises data gateway, a secure bridge that links your local data sources to the cloud. This allows you to create dynamic, auto-refreshing reports without ever having to manually upload a file again. This guide will walk you through every step, from choosing the right gateway mode to installing, configuring, and connecting your first data source. The on-premises data gateway is an application you install on a local computer or server that acts as a secure data pipeline between your on-premises data sources (like a SQL Server database, a folder...

Essentially, Power BI lives in the cloud, but a significant amount of business data still resides on-premises, behind company firewalls. The gateway creates a secure, encrypted channel to bridge this gap. When a Power BI report in the cloud needs to refresh its data, it sends a query through the gateway. The gateway then forwards this query to the on-premises data source, retrieves the data, and securely sends it back to Power BI to update your visuals. This is crucial for two key Power BI features: Before installing, you need to decide which gateway mode is right for you.

Microsoft offers two options, each designed for different scenarios. Access to this page requires authorization. You can try signing in or changing directories. Access to this page requires authorization. You can try changing directories. An on-premises data gateway is software that you install in an on-premises network.

The gateway facilitates access to data in that network. As we explain in the overview, you can install a gateway either in personal mode, which applies to Power BI only, or in standard mode. We recommend standard mode. In that mode, you can install a standalone gateway or add a gateway to a cluster, which we recommend for high availability. In this article, we show you how to install a standard gateway, how to add another gateway to create a cluster, and how to install a personal mode gateway. Organizations today face significant challenges in integrating data across cloud and on-premises environments.

As businesses adopt more cloud services while maintaining existing on-premises infrastructure, establishing reliable connections between these environments becomes critical. The on-premises data gateway serves as a crucial bridge, enabling secure and efficient data transfer without compromising security or performance. This comprehensive guide explores the fundamentals of on-premises data gateways, their implementation in Power BI and other Microsoft services, installation processes, and best practices for enterprise deployment. An on-premises data gateway is a software component that facilitates secure data transfer between local data sources and cloud services. It acts as an intermediary, installed within an organization’s network, that establishes outbound connections to the Microsoft cloud and provides cloud services with controlled access to on-premises resources. The gateway eliminates the need to migrate databases to the cloud while allowing cloud services to utilize this data.

The gateway maintains a secure, encrypted connection channel and handles authentication between cloud services and your local data sources. It enables organizations to leverage cloud capabilities like visualization, automation, and analytics while keeping sensitive data within their network perimeter. This architecture maintains security compliance requirements while providing the flexibility to work with cloud-based productivity tools. Power BI Data Gateway is a specialized implementation of the on-premises data gateway specifically optimized for Power BI services. It enables Power BI users to schedule automatic data refreshes, create real-time dashboards, and build reports using on-premises data sources without manually transferring files to the cloud. The gateway supports a wide range of data connections, including SQL Server, Oracle, SAP, SharePoint, and file-based systems.

While the standard on-premises data gateway serves multiple Microsoft cloud services, the Power BI Gateway offers specific features tailored to business intelligence needs, including query optimization for analytical workloads, support for DirectQuery mode (allowing... Power BI Gateway also enables report sharing and collaboration through the Power BI service while maintaining a secure connection to the underlying data sources. In today’s data-driven world, organizations often deal with data coming from different sources and platforms. Microsoft’s on-premises data gateway provides a solution to seamlessly migrate and exchange data between cloud-based applications and on-premises data sources. This article explores the various applications of the Microsoft Data Gateway and how it enables secure and efficient data transfer. The Microsoft Data Gateway is a software application that establishes a secure connection between an on-premises data source and a cloud-based service.

It enables quick and secure data transfer between these two sources, allowing organizations to access on-premises data in cloud services while maintaining their databases and data sources on their local networks. There are several reasons why organizations choose to use a data gateway: Microsoft Data Gateway comes in three types, each with multiple applications: To install the Microsoft Data Gateway, you need to meet the following minimum requirements: Access to this page requires authorization. You can try signing in or changing directories.

Access to this page requires authorization. You can try changing directories. We've split the on-premises data gateway docs into content that's specific to Power BI and general content that applies to all services that the gateway supports. You're currently in the Power BI content. To provide feedback on this article, or the overall gateway docs experience, scroll to the bottom of the article. An on-premises data gateway is software that you install in an on-premises network.

The on-premises data gateway facilitates access to data in that network and acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several... These cloud services include Power BI, PowerApps, Power Automate, Azure Analysis Services, and Azure Logic Apps. By using a gateway, organizations can keep databases and other data sources on their on-premises networks, yet securely use that on-premises data in cloud services. This article helps you understand the purpose and functionality of the on-premises data gateway so you can securely transfer and use on-premises data in various Microsoft cloud services. Keep reading to learn about how to bridge the gap between on-premises data and cloud services. At the 2024 Fabric Community Conference Microsoft announced support in the On-premises data gateway for Microsoft Fabric Data Pipelines and Data Flows (Gen2).

This post explains how this feature works and demonstrates how to access On-Prem SQL Server data from a Fabric Workspace The on-premises data gateway has been available for quite some time and is frequently used to refresh Power BI cloud-based semantic models from on-premises data sources. As of March 2024, the on-premises gateway supports Fabric data integration tools as gateway data consumers. This essentially means we can connect to on-premises data via a secure connection and pull data into the Fabric OneLake environment as part of scheduled jobs. The Microsoft gateway deployment documentation is comprehensive, so I'll skip the detailed setup instructions. Instead, I'll walk through how I tested it, some observations about how to best use it, and wrap up with some thoughts about the feature as it currently exists.

To test the gateway, I setup a VM-based on-premises lab environment with an Active Directory controller, a single SQL Server 2022 Enterprise instance, and a dedicated VM to run the on-premises data connector. Access to this page requires authorization. You can try signing in or changing directories. Access to this page requires authorization. You can try changing directories. Currently, Microsoft actively supports only the last six releases of the on-premises data gateway.

We release a new update for data gateways every month. Beginning on March 15, 2023, any Power BI dataflow using an on-premises data gateway version older than April 2021 might fail. To ensure your refreshes continue to work correctly, be sure to update your gateway to the latest version and sign in to it. The on-premises data gateway is a locally installed Windows client application that acts as a bridge between your local on-premises data sources and services in the Microsoft cloud. It provides quick and secure data transfer and requires no inbound ports to your network—only outbound ports to reach the Azure web service to which the gateway connects. The gateway functions with multiple services including Azure Analysis Services, Azure Data Factory, Azure Logic Apps, Microsoft Fabric, Power Apps, Power Automate, and Power BI.

Access to this page requires authorization. You can try signing in or changing directories. Access to this page requires authorization. You can try changing directories. The on-premises gateway allows Power Apps and Power Automate to reach back to on-premises resources to support hybrid integration scenarios. The gateway enables Azure Service Bus relay technology to securely allow access to on-premises resources.

The gateway service must run on a local server in your on-premises location. The server does not have to be the same one as the resources it will proxy access to. However, it should be on the same local network to reduce latency. It does also need to be able to access the target resource with as low of latency as possible. Multiple application and flow connections can use the same gateway install. You can only install one gateway on a server.

During the install process, the gateway is set up to use NT Service\PBIEgwService for the Windows service sign in. You can switch this to a domain user or managed service account if you’d like.

On Premises Data Gateway

People Also Search

Keep Your Data In Power BI, PowerApps, Logic Apps, And

Essentially, Power BI Lives In The Cloud, But A Significant

Microsoft Offers Two Options, Each Designed For Different Scenarios. Access

The Gateway Facilitates Access To Data In That Network. As

As Businesses Adopt More Cloud Services While Maintaining Existing On-premises