Power BI on-premises data gateway: how it works and when you need it
The Power BI on-premises data gateway is software you install inside your network so the cloud service can reach local data. It acts as a bridge, because the service cannot see a database behind your firewall by itself. With it in place, scheduled refresh and live queries work against local sources. The sections below explain the modes, the setup and the faults that teams meet most.
- Bridge to local data
- Outbound connections only
- Cluster for uptime
Last updated
What is the Power BI on-premises data gateway?
It is a Windows application from Microsoft that runs on a machine inside your network. The service sends a request, and the gateway passes it to the local source and returns the result. So a SQL Server in your server room can feed a report in the cloud.
Microsoft documents that the software makes outbound connections only. As a result, you do not open inbound ports in the firewall. That design is a main reason security teams accept it.
The same software also serves other Microsoft cloud tools, such as Power Apps and Power Automate. Therefore one install can support several products, which is worth knowing before each team sets up its own. For hands-on help installing and clustering one, see Power BI gateway setup.
Gateway modes compared: standard, personal and virtual network
Microsoft offers three options, and the right one depends on who shares the connection.
| Option | Who uses it | Main point |
|---|---|---|
| Standard mode | Many users and many sources | Central control and shared connections |
| Standard mode in a cluster | Teams that need high availability | Another member takes over if one fails |
| Personal mode | One person only | Cannot be shared with other users |
| Virtual network data gateway | Sources inside an Azure virtual network | Microsoft manages it, no local install |
| No gateway | Cloud sources the service can reach | Nothing to install or patch |
When do you need a gateway for your reports?
You need one when the data sits where the cloud service cannot reach it. Typical cases are a database on a local server, a file share or an ERP system inside the company network. Cloud sources such as a public SaaS API usually connect without it.
The query mode matters too. Import models use the gateway during refresh, while DirectQuery and live connections use it for every reader click. So a DirectQuery report puts steady load on the gateway machine.
Mixed models need care. If one model combines a cloud source and a local one, the refresh may need the gateway for both. Check the Microsoft documentation for that case before you design around it.
How to set up the Power BI on-premises data gateway
Microsoft describes the same broad sequence, and each stage has one decision that matters.
Pick the machine
First, choose a server that stays on and sits close to the data. A laptop is a poor host, because refresh fails whenever it sleeps.
Install and register
Then download the installer, sign in and name the gateway. Store the recovery key safely, since you need it to restore or move the install.
Add the connections
After that, create a connection for each source in the service. The credentials stay with the connection, so report authors never see the password.
Map the semantic models
Finally, point each semantic model at its connection and set the refresh schedule. Also grant access to the authors who will publish more models later.
Power BI on-premises data gateway faults and how to avoid them
Most failures have dull causes. A password expired, the host rebooted for updates or the service account lost access to the database. So use a dedicated service account and watch its expiry date.
Version drift is another cause. Microsoft releases gateway updates often and supports only recent versions. Therefore plan a regular update slot instead of waiting for a fault.
A single gateway is also a single point of failure. A cluster of two or more members keeps refresh running while one machine is down. However, keep all members on the same version, because mixed versions can behave in odd ways.
Gateway questions that Power BI teams ask
Does the Power BI on-premises gateway copy data to the cloud?
The gateway itself stores no business data. It passes queries and results between the service and your source. With an import model, the results then sit in the semantic model in the service. With DirectQuery, the data stays in the source and only query results travel. So the model type decides where the data lives.
Is there a license cost for the data gateway?
Microsoft offers the gateway software as a free download. However, the people who publish and share reports still need suitable Power BI licenses, and the host machine has its own running cost. License terms change, so confirm the current position on Microsoft's site. We do not resell licenses, so our advice is neutral.
Can one Power BI data gateway serve several workspaces?
Yes. A standard mode gateway belongs to the tenant, not to one workspace. Any semantic model can use it, as long as its owner has access to the right connection. As a result, one well-run cluster often serves a whole company. Personal mode is different, because only the person who installed it can use it.
Where should the gateway machine sit in the network?
Place it close to the data sources, since distance adds delay to every query. It also needs a stable outbound route to the internet. A dedicated server or virtual machine that never sleeps is the usual choice. Finally, avoid sharing the host with heavy workloads, because refresh jobs can use a lot of memory.
Can someone set up and document the gateway for us?
Yes. Power BI Agency installs, clusters and documents gateways. The work happens online, with your IT team granting access to the host. We are a division of Sataware Technologies and independent of Microsoft. Call (480) 485-7373 or book the free 30-minute assessment to talk it through.
Let's build your first dashboard together.
Tell us what you report on today. A consultant replies within 2 hours with next steps.
Trusted partners
Microsoft Solutions Partner · AWS Partner
Cloud & AI Platforms
Azure SQL, Microsoft Fabric and the data pipelines behind your reports.
AI Business Solutions
Power BI reporting on your Dynamics 365, Business Central and Power Platform data.
Security
Row-level security and Entra ID sign-in on every report and workspace.
Amazon Web Services
Power BI on your AWS data, with connectors for Redshift, Athena and S3.