Trace Id is missing

Connect to on-premises data sources with a Power BI gateway

Keep your dashboards and reports up to date by connecting to your on-premises data sources without the need to move the data. Query large datasets and take advantage of your existing investments. Get the flexibility you need to meet individual needs, and the needs of your organization.
Overview

Secure, easy access to your on-premises data

One gateway for all your cloud services

Install once and deploy multiple on-premises data connections across Power BI, Power Apps, Power Automate, and Azure Logic Apps using the same gateway.

Easy setup

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.

Secured access to data

Data transfer between Power BI and the on-premises data 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.
Standard vs Personal Mode

Compare gateway modes

Compare gateway models

Features
On-premises data gateway (standard mode)
On-premises data gateway (personal mode)

Cloud services it works with

Power BI, Power Apps, Azure Logic Apps, Power Automate, Azure Analysis Services, Dataflows

Power BI

Serves multiple users with access control per data source

Included

Runs as an app for users who aren’t administrators

Included

Runs as a single user with your credentials

Included

Import data and set up scheduled refresh

Included
Included

DirectQuery support

Included

Support for a live connection to Analysis Services

Included

Take the next step

Start using Power BI for free

Find insights within your data and share rich analytics reports by trying Power BI free in Microsoft Fabric.

Contact Sales

Connect with a sales specialist via chat or by calling 1 855-270-0615Available M-F 6 AM to 3 PM PT.

Request we contact you

Submit a request for a Microsoft specialist or partner to contact you within two business days.

Follow Power Platform

AI-powered assistant