How to Use Data Gateway in Power BI

Connecting your cloud dashboards to data that lives on a local server can feel like a major hurdle. The Power BI Data Gateway is the bridge that makes this connection seamless and secure, letting you refresh your reports with on-premises data automatically. This tutorial will walk you through exactly how to set up, configure, and use the gateway so your cloud reports always have the latest data from your local servers.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is a Power BI Data Gateway and Why Do You Need It?

Think of the Power BI service as an island floating in the cloud. Your on-premises data, like a SQL Server database, an Excel file on a network share, or another local data source, lives behind your company’s firewall on the mainland. Power BI can’t just reach out and grab this data because your firewall is doing its job and blocking outside connections.

The On-premises Data Gateway is a small, secure application you install on a computer within your local network (the mainland). It acts as a guarded bridge, creating a secure, outbound tunnel to the Power BI service. When it's time to refresh a report, Power BI sends a request to the gateway, which then queries your firewalled data source, retrieves the fresh data, and securely sends it back to the cloud to update your dashboard. No complex firewall configuration is needed, and your data remains protected.

Gateway Modes: Standard vs. Personal

When you install the gateway, you’ll have to choose between two modes. Understanding the difference is crucial for setting up your environment correctly.

• On-premises data gateway (Standard Mode): This is the recommended choice for most organizations. It allows multiple users to connect to multiple on-premises data sources. You can share access with your team, making it perfect for collaborative business intelligence environments where several people publish and refresh reports. This guide will focus on setting up the standard gateway.
• On-premises data gateway (Personal Mode): This mode is designed for a single user. It runs as an application and can only be used by the person who installed it. It’s a good fit for an individual analyst who needs to refresh reports themselves and won’t be sharing the gateway connection with others. However, it has more limitations than standard mode and cannot scale as your team grows.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Before You Begin: Requirements & Best Practices

Before jumping into the installation, a little preparation can save you a lot of headaches down the road. Make sure your environment meets the necessary requirements and follow these best practices for a stable, high-performance setup.

System Requirements

The machine where you install the gateway should meet a few minimum specifications:

• .NET 4.8 Framework
• A 64-bit version of Windows 8 / Windows Server 2012 R2 or a later version
• At least 4 GB of SSD disk space
• A minimum of 8 GB RAM and 8 CPU Cores is recommended for optimal performance
• A Power BI account (a Pro or Premium license is required to publish and automatically refresh reports)

Best Practices for a Smooth Setup

• Choose the Right Machine: Install the gateway on a computer that is always on and connected to the Internet. A server is the ideal candidate. Avoid installing it on a personal laptop that might go to sleep, shut down, or disconnect from the network.
• Network Connection Matters: For the best performance, place the gateway machine on a reliable, fast network with a clean line of sight to your data sources. While you don't have to install it on the same machine as the data source, a good connection between them is vital for quick refreshes.
• Avoid Domain Controllers: Do not install the gateway on a domain controller. This is an official Microsoft recommendation to avoid potential security and performance conflicts.
• Plan for Updates: Microsoft regularly releases updates for the gateway with performance improvements and security patches. Plan to update your gateway at least every few months to stay current.

Step-by-Step: Installing the Power BI Gateway

Once you've prepared your environment, the installation process is straightforward. Follow these steps to get the standard gateway up and running.

Step 1: Download the Gateway

First, you need to download the installer. You can do this directly from the Power BI service.

1. Log in to your Power BI account at app.powerbi.com.
2. Click the download icon (a down arrow) in the top-right corner of the screen.
3. Select "Data Gateway" from the dropdown menu. This will take you to the download page, where you can get the latest version of the standard mode installer.

Step 2: Run the Installer

Locate the downloaded file and run it. You’ll be greeted by an installer wizard that guides you through the process. Accept the terms of use and specify the installation path (the default location is usually fine).

Step 3: Choose Your Gateway Mode

The installer will ask you to select a gateway mode. For this tutorial, select On-premises data gateway (recommended), which is the standard mode. Click "Next" to proceed.

Step 4: Sign In to Your Power BI Account

Next, you’ll be prompted to sign in with your Power BI service account credentials (the same email address you use for Power BI). This critical step links the gateway installation to your Power BI tenant, allowing them to communicate.

Step 5: Configure the Gateway

After successfully signing in, you need to configure the gateway itself:

1. Select Register a new gateway on this computer.
2. Give your gateway a unique and descriptive name. This is especially helpful if your organization will have multiple gateways (e.g., "Sales Department - SQL Gateway").
3. You must create a Recovery Key. This key is like a master password for your gateway. Write it down and store it in a secure location. You will absolutely need it if you ever have to restore, migrate, or take over a gateway. Without it, you will have to recreate all your data source connections from scratch.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 6: Finalize Installation

Once you’ve entered the name and recovery key, click Configure. The installer will finalize the setup. After a moment, you'll see a confirmation screen letting you know that the gateway is online and ready to use. You're now ready to manage your data sources from the Power BI service.

Managing and Configuring Your Gateway Online

Now that the gateway software is installed, all further management - like adding data sources and permissions - happens in the Power BI Service.

Step 1: Locate Your Gateway in Power BI

1. Go back to your browser and navigate to app.powerbi.com.
2. Click the Settings gear icon in the top-right corner.
3. Select Manage connections and gateways.

On this page, you’ll see a list of all data gateways your account has permission to manage. You should see the gateway you just installed with a green "online" status indicator.

Step 2: Add a Data Source to the Gateway

The gateway itself is just a bridge, now you need to tell it which data sources it can connect to on your local network. Here's how to add a common data source like SQL Server:

1. In the "Manage connections and gateways" screen, select your gateway.
2. Click the + New button at the top to add a new connection.
3. A form will appear. Fill out the details for your on-premises data source:
4. Enter the username and password for the service account.
5. Click Create. Power BI will test the connection. If successful, you'll see a message confirming the connection was created.

You have now defined a connection that the Power BI service can use through your gateway!

Step 3: Manage User Permissions

Finally, you need to grant other users permission to use this gateway connection. On the same data source settings page, go to the Users tab. Here, you can type in the email addresses of colleagues who you want to allow to create a report with a connection to this data source. This doesn't give them access to the data itself only the ability to route their Power BI datasets through your established, credentialed connection.

Using the Gateway: Refreshing Your First Report

With everything configured, it's time for the final piece: connecting a Power BI report and setting up an automated refresh.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Publish a Report from Power BI Desktop

If you haven’t already, create a simple report in Power BI Desktop that connects to your on-premises data source (the same one you just added to the gateway). Once done, click the Publish button on the Home ribbon and select a workspace in the Power BI service.

Step 2: Map the Dataset to the Gateway

Once published, head to the Power BI service and find the dataset for the report you just uploaded.

1. Navigate to the workspace where you published your report.
2. Find your dataset in the list (it will likely have the same name as your .pbix file), click the three dots (...), and choose Settings.
3. Expand the Gateway and cloud connections section.
4. Power BI will show that your on-premises data source connection is not configured. Under "Maps to," select the gateway data source connection you created in the previous section.
5. Click Apply. You should see a message indicating the mapping was successful.

Step 3: Schedule a Refresh

Your dataset is now linked to your on-prem data via the gateway. The last step is to tell Power BI when to pull fresh data.

1. In the same dataset settings page, expand the Scheduled refresh section.
2. Toggle the switch to turn it on.
3. Choose your refresh frequency (e.g., Daily, Weekly), select your time zone, and add the times you want the refresh to run.
4. Click Apply.

And that's it! Power BI will now automatically use the gateway to refresh your dataset according to the schedule you set, ensuring your report always displays the latest information without any manual intervention.

Final Thoughts

Setting up a Power BI Data Gateway is a foundational skill for any analyst wanting to connect the powerful Power BI service to valuable on-premises data. By following these steps, you’ve built a secure and reliable bridge that automates data refreshes, freeing you up to focus on finding insights, not manually updating reports.

While the gateway automates the data pipeline, the work of creating dashboards and finding those insights can still feel manual - navigating complex builders and trying to translate business questions into charts. At Graphed, we’ve focused on automating that next layer. By connecting to your data sources, we enable you to instantly build dashboards and get answers just by asking simple questions in plain English - no wrestling with drag-and-drop interfaces required. It’s the easiest way to turn your raw data into clear, actionable reports.