What is an on-premises data gateway?
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.
The on-premises data gateway acts as a bridge. It provides quick and secure data transfer between on-premises data, which is data that isn't in the cloud, and several Microsoft cloud services. These services include Power BI, Power Apps, 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 while securely using that on-premises data in cloud services.
How the gateway works
For detailed information on how the gateway works, see On-premises data gateway architecture.
Types of gateways
There are two different types of gateways, each for a different scenario.
On-premises data gateway: Allows multiple users to connect to multiple on-premises data sources. With a single gateway installation, you can use an on-premises data gateway with all supported services. This gateway is well-suited to complex scenarios where multiple people access multiple data sources.
On-premises data gateway (personal mode): Allows one user to connect to data sources and can’t be shared with others. An on-premises data gateway (personal mode) can be used only with Power BI. This gateway is well-suited to scenarios where you’re the only one who creates reports and you don't need to share any data sources with others.
Using a gateway
There are four main steps for using a gateway.
- Download and install the gateway on a local computer.
- Configure the gateway based on your firewall and other network requirements.
- Add gateway admins who can also manage and administer other network requirements.
- Troubleshoot the gateway in case of errors.
- Logic Apps, Power Apps, and Power Automate support both read and write operations through the gateway:
- Write operations have a 2-MB payload limit.
- Read operations have a 2-MB request limit and an 8-MB compressed data response limit.
- URL for the GET request has a 2048 character limit.
- While using the gateway with Power BI in Direct Query Mode, there is a 16-MB uncompressed data response limit.
- For information about installation considerations, see Related considerations.
This document contains general information about the on-premises data gateway that applies to all services that the gateway supports. You can obtain more on-premises data gateway information for specific products by visiting the following product-specific sites.