With the on-premises gateways, you can keep your data fresh by connecting to your on-premises data sources without the need to move the data. Query large datasets and benefit from your existing investments. The gateways provide the flexibility you need to meet individual needs, and the needs of your organization.
Install once and deploy multiple on-premises data connections across Power BI, PowerApps, Microsoft Flow and Azure Logic Apps using the same gateway.
Download and install the gateway with minimal interactions. Then sign in with your organization account to register the gateway to be used by cloud services.
Data transfer between Power BI and the gateway is secured through Azure Service Bus. Credentials provided by gateway administrators are encrypted to help protect your information in the cloud and only decrypted on the gateway machine.
On-premises data gateway | On-premises data gateway (personal mode) |
|---|
| Cloud services it works with | Power BI, PowerApps, Azure Logic Apps, Microsoft Flow | Power BI |
| Serves multiple users with access control per data source | • | |
| Runs as an app for users who aren't administrators on the computer | • | |
| Runs as a single user with your credentials | • | |
| Import data and set up scheduled refresh | • | • |
| Support for DirectQuery to SQL Server, Oracle, Teradata | • | |
| Support for a live connection to Analysis Services | • | |
| Monitoring and auditing for gateway and data sources | Coming soon |