Power BI gateway setup that keeps refresh running
Power BI gateway setup connects the cloud service to data that lives inside your own network, such as a SQL Server database or a file share. The on-premises data gateway carries queries in and results out, so reports can refresh without anyone uploading files. One of our consultants installs it on the right machine, secures the credentials and tests each source.
- Installed on the right server
- Cluster for uptime
- Every source tested
Last updated
What does a Power BI gateway setup do?
The Power BI service runs in Microsoft's cloud. Your accounting database, however, may sit on a server in your own building. The cloud cannot reach into that network by itself, and it should not.
The on-premises data gateway solves this. It is a small program that runs on a machine inside your network. When a refresh starts, the gateway receives the request, runs the query against the local source and sends the result back.
Because the gateway opens the connection outward, you do not need to open inbound ports in the firewall. Credentials for each source stay encrypted. So the design keeps your network closed while the reports stay current. For example, a Power BI warehouse dashboard that reads a local SQL Server needs this link for every refresh.
What a careful Power BI gateway installation includes
A gateway takes minutes to install, but these choices decide whether it stays reliable.
Server choice
We pick a machine that stays on, sits close to the data and has spare memory. A laptop under a desk does not qualify.
Standard mode
Standard mode serves many users and sources. Personal mode, by contrast, suits one person only, so we rarely advise it for a team.
Gateway cluster
A second machine joins the first in a cluster. Then refresh carries on when one server restarts for updates.
Recovery key storage
The recovery key lets you restore or move the gateway later. We make sure it lands in your password vault.
Data source permissions
Each source gets named users, because authors should only reach the connections their reports need.
Update routine
Microsoft releases new gateway versions often. We also agree who applies them and how to test afterwards.
Why do gateway refreshes fail so often?
Most failures trace back to a few causes. A service account password expires, and every source using it stops at once. Or the gateway machine goes to sleep, and the early refresh finds nobody home.
Capacity is another cause. When many models refresh at the same hour, the gateway machine runs short of memory. As a result, jobs time out even though nothing is wrong with the data.
Finally, an old gateway version can fall out of support. Then a change in the service breaks a connection that worked for years. A short monthly routine prevents nearly all of these, which is why we leave one behind. For how the gateway itself works, see our Power BI on-premises data gateway guide.
Signs your Power BI gateway setup needs a review
Any of these is a reason to look again at how the gateway runs.
- Refresh fails several times each month
- The gateway runs on someone's own PC
- Only one person knows the recovery key
- Nobody has updated it in a long while
- All models refresh at the same hour
- A single server carries every source
How our Power BI gateway setup runs
Four steps take you from an unreliable connection to one your team can maintain.
Review the sources
First we list every local source, who owns it and how often it must refresh, so the design fits real needs.
Install and register
Then we install the gateway with your IT team on a call, register it to your tenant and store the recovery key.
Connect and test
Each data source gets its own connection and a test refresh, because a gateway that installs cleanly can still fail on one source.
Document and hand over
After that your administrators receive a short runbook that covers updates, password changes and what to check when a job fails.
Gateway questions from IT and reporting teams
Does every Power BI report need a gateway?
No. Reports that read only cloud sources, such as SharePoint Online or an Azure SQL database, usually refresh without one. A gateway becomes necessary when the data sits inside your private network. So before any installation we check each source, because some teams install a gateway they do not actually need.
Is the Power BI gateway safe for our network?
The gateway makes outbound connections only, so you do not open inbound firewall ports for it. Source credentials stay encrypted, and Microsoft documents the design in detail. Still, the machine that hosts it deserves the same care as any server. We therefore agree access, patching and monitoring with your IT team first.
Where should the gateway for Power BI sit?
It should sit on a server that stays on, has a stable wired connection and sits near the data sources. Microsoft advises against certain machines, such as a domain controller. We review your options with IT and choose a host, and for important reports we add a second server as a cluster.
Can one Power BI gateway serve several departments?
Yes. A standard mode gateway can hold many data sources, and each source has its own list of allowed users. So finance and operations can share the same cluster without seeing each other's connections. However, heavy use by one team can slow the others, so we watch the load after launch.
Do you install the gateway yourselves?
We guide the installation on a shared screen while your IT administrator signs in, since the machine and the accounts belong to you. That way no passwords pass to us. All our work is remote, and a written quote lists the sources we cover before we begin.
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.