How to Install Power BI Gateway on Server

Setting up a Power BI data gateway is the essential first step to automatically refreshing reports that rely on data stored on your local network. It acts as a secure bridge, letting the cloud-based Power BI service talk to your on-premises data sources like SQL servers or local Excel files. This guide will walk you through every step of installing and configuring the gateway on a server so you can stop manually refreshing your dashboards.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is the Power BI Gateway (and Why Do You Need It)?

The Power BI On-premises data gateway is a piece of software you install on a computer within your local network. Its whole purpose is to function as a gatekeeper, securely transferring data from your on-premises sources to the Power BI Service in the cloud.

Without it, any report you publish to PowerBI.com that uses a local source (like an Excel file on a shared drive or a local SQL Server database) is just a static snapshot. If you want to see updated data, you have to manually open the .PBIX file in Power BI Desktop, hit refresh, and republish the report. Every. Single. Time.

The gateway solves this by creating a secure pathway for automatic refreshes. Once it's set up, you can schedule your reports to update daily, hourly, or even more frequently, ensuring your team is always looking at the latest data without any manual effort.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Standard Mode vs. Personal Mode

When you install the gateway, you will get two options. Let’s make the choice simple:

• Standard Mode: This is the mode you should almost always use, especially when installing on a server. It’s designed for multiple users and supports both scheduled refresh (Import mode) and live queries (DirectQuery/Live Connection). It runs as a service in the background, making it robust for business use.
• Personal Mode: This mode is for a single user and only supports scheduled refreshes (Import mode). It runs as an application under your user account, meaning you must be logged in for it to work. You should only use this in specific, limited scenarios, not on a production server.

This tutorial will focus exclusively on the Standard Mode gateway, as it is the best practice for any team or business environment.

Before You Begin: Prerequisites and System Requirements

Before you jump into the installation, a quick check of your server's setup can save you a lot of headaches later. Think of this as your pre-flight checklist.

Server Requirements:

• Operating System: Windows Server 2016 or later is recommended. The gateway can also be installed on Windows 10/11 (64-bit), but a dedicated server is ideal for performance and reliability.
• .NET Framework: Version 4.8 or later (the installer will typically prompt you if it's missing).
• RAM (Memory): Minimum of 8 GB.
• CPU (Processor): Minimum of 8 CPU cores.
• Hardware Tip: It’s best practice to install the gateway on a dedicated machine that is always on and connected to your network. Installing it on someone's personal laptop is a recipe for refresh failures when they go on vacation!

Permissions and Accounts:

• Local Admin Rights: You must have administrative privileges on the server where you are installing the gateway.
• Power BI Account: You need a work or school account to sign into the Power BI Service (e.g., user@yourcompany.com). A Pro or Premium per User (PPU) license is required to publish and manage reports that use the gateway.

Network Configuration:

The gateway needs to communicate with the Azure Service Bus. You need to ensure your server’s firewall allows outbound connections to specific ports and domains. While it often works without configuration on standard corporate networks, if you have a strict firewall, ensure the following are not blocked:

• Outbound TCP Ports: 443 (required), 5671, 5672, and 9350-9354.
• A detailed list of required domains is available in Microsoft’s documentation if your network administrators need to whitelist specific endpoints. For most setups, this isn’t needed.

Step-by-Step Guide to Installing the Power BI Gateway

With the prerequisites out of the way, it’s time for the installation. This part is surprisingly straightforward.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Download the Gateway Installer

First, head over to the Power BI Service and download the latest version of the gateway.

1. Navigate to app.powerbi.com and sign in.
2. Click the download icon (a down arrow) in the top-right corner of the page.
3. Select “Data Gateway” from the dropdown menu. This will open the download page.
4. Click the “Download gateway” button to get the installer .exe file.

Move the downloaded installer file to the server where you intend to run the gateway.

Step 2: Run the Installer and Sign In

Double-click the installer file to begin the setup process.

1. On the first screen, choose an installation location (the default is usually fine) and accept the license terms. Click Install.
2. Once the installation is complete, you'll be prompted to enter an email address to use with the gateway. Enter the email address for your Power BI work or school account and click Sign in.
3. Complete the sign-in process with your work account credentials.

Step 3: Register and Configure Your New Gateway

After signing in, you need to register the gateway to link it with your Power BI tenant.

1. Select the option to “Register a new gateway on this computer” and click Next.
2. Name your Gateway: Give your gateway a descriptive name. Something like “Company-Data-Gateway-Prod” is much more helpful than “Gateway.” This name will appear in the Power BI Service, so make it recognizable.
3. Create a Recovery Key: This is one of the most important steps. You'll need to create and confirm a recovery key with at least eight characters. Think of this key as the master password for your gateway. You'll need it if you ever have to migrate, restore, or take over ownership of this gateway on another machine. Store this key somewhere safe and secure, like a password manager. If you lose it, you cannot recover it.
4. Once you've entered the name and recovery key, click Configure.

The installer will finalize the setup. If all goes well, you'll see a confirmation screen telling you that your new gateway is online and ready to be used. The gateway is now installed and running as a service on your server.

Configuring Data Sources in the Power BI Service

Just because the gateway is running on your server doesn't mean Power BI knows what data to connect to. The next step is to tell the gateway which specific on-premises data sources it's allowed to access.

Step 1: Find Your Gateway Online

Go back to the Power BI Service in your web browser.

1. Click the settings gear icon in the top right.
2. Select “Manage connections and gateways.”
3. You’ll land on a page with two tabs. Click on the “On-premises data gateways” tab.
4. You should see the gateway you just installed listed by name with a green status indicator showing it is “online.” This is great confirmation that your server is communicating correctly.

Step 2: Add a New Connection

Now, let's create a connection to a specific data source. We'll use a SQL Server database as a common example.

1. At the top of the “manage connections and gateways” page, click the + New button.
2. Select On-premises as your connection type.
3. Give your connection a unique name. For example, “Finance_SQL_Database_Prod”.
4. In the Gateway cluster name dropdown, select the gateway you just created.
5. For Connection type, choose your data source type (e.g., SQL Server, Oracle, SharePoint, File, etc.).
6. Fill out the data source settings. For SQL Server, this would be:
7. Authentication Method: This is critical. You need to provide credentials that the gateway can use to access the database.
8. Click Create. The Power BI service will use the gateway to test the connection. If all credentials and server names are correct, you will see a success message.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Grant Users Access

By default, only you can use this new connection. You need to grant access to other Power BI users on your team so they can build and refresh reports with it.

1. Navigate back to the connection you just created under Data > Connections and Gateways.
2. Click the ellipsis (...) next to the connection name and select Manage users.
3. Type in the email address of a colleague and select their permissions level (typically "User" which allows them to connect, or "User + share" to let them share reports that use this source).
4. Click Add. Repeat for all team members who will need this connection.

Connecting a Report and Scheduling a Refresh

You’ve done all the hard work! Now for the payoff: enabling automatic refresh.

1. First, publish a Power BI report from your Desktop that uses the same on-premises data source you just configured (e.g., the Finance SQL Database).
2. In the Power BI service, go to your workspace and find the dataset for the published report (it will have the orange dataset icon).
3. Click the ellipsis (...) next to the dataset and go to Settings.
4. Expand the Gateway and cloud connections section.
5. Now, expand the Scheduled refresh section.
6. Toggle the “Keep your data up to date” switch to On.
7. Set your desired refresh frequency (daily, weekly), select your time zone, and add the times you want the report to update. You can add multiple refresh times per day depending on your license type.
8. Click Apply.

That's it! Your report will now automatically fetch new data from your on-premises server according to the schedule you defined, keeping your dashboards fresh and available for decision-makers.

Final Thoughts

Setting up the Power BI Gateway correctly is a game-changer for teams that rely on on-premises data. By creating that secure bridge to the cloud and scheduling refreshes, you automate a manual process, save valuable time, and build more trust in your reports because you know they’re always current.

While managing a server for your BI tools is a solid approach for on-prem data teams, many people still connect dozens more applications that get left behind. We find that all your valuable marketing & sales data is usually a lot messier to wrangle than your traditional business data sources - that's why we built Graphed to simplify things. Since you only have to connect your platforms once, we help you get insights from Google Analytics, Facebook Ads, Shopify, & Salesforce with just an English prompt.