On-Premises Data Gateway

Power BI · Power BI Service

Theory

The on-premises data gateway is software installed on a computer inside your network that acts as a secure bridge between the Power BI Service in the cloud and data sources that the cloud cannot reach directly, such as a SQL Server in the office or files on a local network share. The gateway makes outbound connections to Azure, so you do not need to open inbound firewall ports.

There are two modes. Standard mode is shared and centrally managed: an admin installs it, adds data source connections, and decides which users can use them; it supports scheduled refresh, DirectQuery and live connections for many people. Personal mode is for a single user, supports only Import refresh, and runs under that user's account, so it is not suitable for team reports. For example, the Sales semantic model connecting to SQL Server 'sql-office-01' is mapped to the company gateway so its 7 AM refresh can reach the database.

Why we use it

Many companies still keep key data on-premises. Without a gateway, published reports on those sources cannot refresh or run DirectQuery from the cloud.

When to use it

Install a standard gateway on an always-on server (not a laptop) when any published model uses on-premises sources. Cloud sources such as Azure SQL Database or SharePoint Online usually do not need one. Use gateway clusters for high availability.

How it works

  1. Published model uses an on-premises source
  2. Install and register a standard gateway
  3. Create a data source connection on the gateway
  4. Grant users access to the connection
  5. Is the semantic model mapped to the connection? Yes: Refresh and DirectQuery work. No: Map it in semantic model settings.
  6. Cloud reports reach on-premises data

Syntax

Install: download 'On-premises data gateway' → sign in → register a new gateway (name + recovery key)
Service: Settings → Manage connections and gateways → New connection (server, database, credentials)
Semantic model → Settings → Gateway and cloud connections → map each source

Example

1. IT installs the standard gateway 'Jaipur-GW' on an always-on server next to sql-office-01.
2. Admin: Manage connections and gateways → New → On-premises → Jaipur-GW → SQL Server sql-office-01 / SalesDB.
3. Add the BI-Developers group as connection users.
4. Semantic model 'Sales Overview' → Settings → Gateway and cloud connections → map to the new connection.
5. Scheduled refresh now succeeds through the gateway.

Key points

Power BI topics

Power BI Introduction

Getting Data

Power Query (Data Transformation)

Data Modeling

DAX (Data Analysis Expressions)

Data Visualization

Dashboards & Reports

Power BI Service

Advanced Features

Projects & Case Studies

Interview & Certification

Advanced DAX & Time Intelligence

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Power BI Dashboards & DAX

Learn data visualization and interactive dashboards step-by-step. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice DAX Online 250 business scenarios on a star schema — write a measure and compare your visual with the expected one. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Power BI  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax / Where to find it
{{ current.syntax }}
Example
{{ current.example }}
What You'll Learn — click to check off
  • {{ pt.mark }} {{ pt.text }}

Share this topic