This is the Trace Id: 96577b8744d026fb73a73f72e5ca79b7
Skip to main content Power BI Product features overview Power BI Desktop Pro Premium Embedded Report Server Microsoft Fabric IQ Fabric Data Factory Fabric Data Engineering Fabric Data Warehousing Fabric Real-Time Intelligence Fabric Data Science Fabric Databases Microsoft OneLake Security and governance Managed application backend Pricing Partners Documentation Data 101 Data Storytelling Power BI Blog Power BI Support Power BI Community Power BI Downloads Migrate Buy now Start free Sign in

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.
Download standard mode Download personal mode
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.
Five people work together in a modern office surrounded by multiple computer monitors and wall-mounted displays showing dashboards, charts, data tables, and a world map. The workspace features white desks, blue chairs, exposed ceiling beams, and large ventilation ducts.

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.
A person sits in an office chair at a desk in a glass-walled workspace, facing a desktop monitor and an open laptop. The desktop screen displays a dashboard with colorful charts, graphs, and data visualizations, while the laptop shows a webpage. A keyboard and mouse are on the desk, with a plant and shelving visible to the left and a blue-and-beige chair to the right.

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.
A presenter in a dark blazer and light turtleneck stands in front of a large display during a presentation. The screen shows a data dashboard with colorful donut charts, bar charts, and other visualizations. Several audience members are visible out of focus in the foreground.
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
Person using a laptop in a café, on a phone call, with a drink on the table and a bicycle on the wall behind.

Contact us

Learn more about our products, discuss use cases, or get pricing information.

Available M-F 6 AM to 3 PM PT.
Chat now

    Call (800) 642 7676

Follow Power Platform

Surface Laptop Ultra Surface Pro Surface Laptop Surface RTX Spark Dev Box Explore Copilot Explore Microsoft products Windows 11 apps Account profile Download Center Microsoft Store support Returns Order tracking Certified Refurbished Why buy from Microsoft Store Flexible Payments Microsoft in education Devices for education Microsoft Teams for Education Microsoft 365 Education How to buy for your school Educator training and development Deals for students and parents AI for education
Microsoft AI Microsoft Security Dynamics 365 Microsoft 365 Microsoft Power Platform Microsoft Teams Microsoft Copilot Small Business Azure Microsoft Developer Microsoft Learn Support for AI marketplace apps Microsoft Tech Community Microsoft Marketplace Software companies Visual Studio Careers About Microsoft Company news Privacy at Microsoft Investors Diversity and inclusion Accessibility Sustainability
English (United States) Consumer Health Privacy Sitemap Contact Microsoft Privacy Manage cookies Terms of use Trademarks Safety & eco Recycling About our ads