How to Set Up Power BI Gateway

Setting up your first Power BI Gateway can feel a bit technical, but it’s the essential bridge that unlocks automated, up-to-date reports from your company's internal data sources. This guide will walk you through exactly what a gateway is, why you need one, and how to install and configure it step-by-step, so you can stop manually uploading data files for good.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is a Power BI Gateway (and Why Do You Actually Need One?)

In simple terms, a Power BI Gateway is a secure piece of software that acts as a bridge or a gatekeeper between your data sources that live inside your company’s network (on-premises) and the Power BI Service, which lives in the cloud.

Imagine your company's sales data sits in a SQL Server in your office, and your Power BI dashboard is hosted on Microsoft's cloud servers. Without a gateway, there’s no safe and simple way for your cloud-based dashboard to ask your internal server for the latest numbers. You'd be stuck exporting data to a CSV or Excel file and manually uploading it to Power BI every time you wanted an update.

The gateway solves this. It’s an application you install on a computer within your network that securely funnels data to the Power BI Service. This enables a feature that almost every business needs: scheduled refreshes. It lets your dashboards and reports automatically update on a set schedule (like every morning at 8 AM), ensuring that the data your team sees is always current, without anyone having to lift a finger.

You need a gateway if your data resides in sources like:

• SQL Server, Oracle databases, or other on-premises databases.
• Excel or CSV files stored on a local computer or company file share.
• SharePoint Server.
• Analysis Services.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Personal Mode vs. On-Premises Gateway (Standard Mode): Which Should You Choose?

When you download the gateway, you’ll be asked to choose between two modes. This decision is important, as it determines how the gateway functions and who can use it.

Personal Mode

Think of this mode as a gateway for one person. It's designed for individual analysts to connect to sources and refresh data for their own reports.

• Runs as an application: It only runs when you are logged into the computer. If you log off or the computer shuts down, the gateway stops working, and data refreshes will fail.
• For a single user: Only you can use the gateway to refresh datasets. You cannot share it with other report creators.
• Supports Import only: It works by importing (copying) data into Power BI. It does not support DirectQuery or Live Connection, which are methods for querying data directly from the source without copying it.

Use Case: Ideal for a solo analyst who works with local files on their own machine and is the only person using their reports.

On-Premises Gateway (Standard Mode)

This is the robust, "corporate" version that almost every business should use. It’s built for teams and automates data connections for the entire organization.

• Runs as a service: It runs in the background on the server. It starts automatically when the computer boots up and runs continuously, even when no user is logged in. This makes scheduled refreshes reliable.
• For teams: Multiple users can be granted permission to use the same gateway, creating a centralized and manageable data connection for the whole department or company.
• Supports all modes: It supports Import, DirectQuery, and Live Connection, giving you much more flexibility in how your reports interact with your data.

Use Case: The standard for any business environment where reports are shared and reliability is crucial. If you have a team, a dedicated server, or need to use DirectQuery, this is the one you need.

Our recommendation? Always go with the On-premises Gateway (Standard Mode) unless you have a very specific, temporary, or individual use case. This guide will focus on setting up the Standard Mode gateway.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Before You Begin: Requirements and Best Practices

To avoid headaches down the line, let's cover a few pre-installation essentials.

System Requirements

The gateway isn't overly demanding, but you should install it on a machine that meets these minimums (always check Microsoft's official documentation for the latest specs):

• .NET 4.7.2 Framework (or newer)
• A 64-bit version of Windows 8 / Windows Server 2012 R2 or newer
• 8 GB of RAM
• An 8 Core CPU

Key Best Practices

Where you install the gateway matters. Keep these tips in mind:

• Use an "Always-On" Computer: Don't install the gateway on your personal laptop that goes home with you, gets closed, or hibernates. Install it on a dedicated server or machine that is always on and connected to your network.
• Keep it Close to the Data: For the best performance, install the gateway on a machine with a low-latency connection to your data source. If you’re connecting to a SQL Server, the ideal place for the gateway is on that same server, if company policy allows.
• Don't Install it on a Domain Controller: This is strongly discouraged by Microsoft for security reasons.
• A Wired Connection is Best: Use a wired network connection instead of Wi-Fi for better reliability and speed.

Step-by-Step Guide to Installing the On-Premises Gateway (Standard Mode)

Ready to get started? Let's walk through the installation process.

1. Download the Gateway: Log in to the Power BI Service (app.powerbi.com). In the top-right corner, click the download icon (a down-facing arrow) and select "Data Gateway." This will take you to the download page. Click to download the standard mode gateway.
2. Start the Installer: Run the downloaded installer file. Accept the terms and click "Install."
3. Enter Your Email: Once installed, you need to sign in. Use the same work or school account that you use for the Power BI Service.
4. Register the Gateway: Select "Register a new gateway on this computer" and click next.
5. Configure the Gateway:
6. Confirmation: After you click "Configure," the system will set everything up. A few moments later, you should see a confirmation screen telling you that your gateway is online and ready to be used.

Connecting Your On-Premises Data Source in Power BI

The gateway is now installed on your server, but Power BI doesn’t know what data to access through it yet. The next step is to configure your specific data sources in the Power BI Service.

1. Manage Gateways in Power BI: In the Power BI Service, click the Settings gear icon in the top right and choose "Manage connections and gateways."
2. Select Your Gateway: On the "On-premises data gateways" tab, you should see the gateway name you just created. Click on it.
3. Add a New Data Source: Check the box "Allow user's cloud data sources to refresh through this gateway cluster" and then click the "New" button near the top.
4. Enter Connection Details:
5. Finalize and Test: Once you fill in the details, click "Create." Power BI will then create the data source connection through your gateway, and you should see a green message saying "Connection Successful."

Graphed

Still Building Reports Manually?

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

Watch the Demo

Scheduling Your First Automatic Data Refresh

This is the final step where it all comes together. Now you can tell a specific Power BI report to use your new gateway connection to refresh its data automatically.

1. Go to Dataset Settings: In your Power BI workspace, find the report dataset you want to automate. Click the three dots beside the dataset name and choose "Settings."
2. Map to Gateway Data Source: In the settings page, find the "Gateway and cloud connections" section. You should see your dataset listed. Use the "Maps to" dropdown menu to select the data source connection you just created in the previous section. Click "Apply."
3. Configure Scheduled Refresh: Further down the page, expand the "Scheduled refresh" section.
4. Save: Click "Apply." Your report is now set to refresh automatically!

You can also trigger a manual refresh at any time by going to the workspace, hovering over the dataset, and clicking the "Refresh now" icon.

Final Thoughts

Setting up a Power BI Gateway is a foundational step for any organization wanting to move from static, manual reports to a dynamic, automated data culture. By connecting the Power BI Service to your local data sources through a secure gateway, you ensure everyone on your team is making decisions based on the freshest data possible.

While configuring a gateway is powerful, it also often highlights the technical barriers involved in traditional business intelligence platforms. We created Graphed because we believe getting insights from your data shouldn’t require server setups and deep technical knowledge. For cloud-based data sources like Google Analytics, Shopify, Facebook Ads, or HubSpot, our platform securely connects everything in a few clicks. You can instantly create dashboards and get real-time answers by simply asking questions in plain English, removing the friction between your data and the decisions you need to make.