How to Connect to Power BI Gateway Data Source

Getting your on-premises data - the information stored on your company's local servers - into a cloud-based tool like Power BI can feel like a complex task. That crucial link is the Power BI Gateway, and while it might sound technical, it's essentially a secure bridge connecting your local data to your online reports. This guide will walk you through exactly what the gateway is, how to install it, and the steps to connect your very first data source so your cloud dashboards stay fresh and accurate.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly Is a Power BI Gateway?

Think of it this way: Power BI lives in the Microsoft cloud, while your SQL Server, Oracle database, or file share lives safely behind your company's firewall on a local network. Power BI can't just reach in and grab that data without a secure, authorized escort. The On-Premises Data Gateway acts as that secure escort.

It’s a small piece of software you install on a computer within your local network. This gateway receives requests for data from the Power BI service, securely fetches that data from your local source, encrypts it, and then sends it back to the cloud to update your reports and dashboards. Without it, your cloud reports would be stuck with a static snapshot of your data, unable to get live updates or scheduled refreshes from your internal databases.

This process is essential for two main reasons:

• Security: It prevents direct, unsolicited access to your internal network from the internet. All communication is initiated from and managed through the secure gateway.
• Accessibility: It allows cloud services to interact with data they otherwise couldn't reach, bridging the gap between your on-site infrastructure and powerful cloud analytics tools.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Personal Mode vs. Standard Mode: Which One Should You Use?

Before you download anything, you need to decide which type of gateway fits your needs. Microsoft offers two different modes, and choosing the right one from the start will save you headaches later.

Personal Mode

As the name suggests, this mode is for a single user. It runs as an application on your personal computer, not as a background service.

• Who it's for: Individual analysts or anyone who needs to connect to on-premises sources for their own reports without sharing them.
• How it works: You run it with your own Power BI credentials. When you need to refresh data, the gateway on your machine wakes up and does the job.
• The big limitation: If you turn off your computer or close the application, the gateway is offline. No refreshes can happen. It is also an island, you cannot share the gateway or your data sources with other team members.

In short, Personal Mode is great for testing or one-off individual projects, but it’s not a robust solution for a team or organization.

Standard Mode (Formerly "On-premises data gateway")

This is the workhorse of Power BI gateways and the one you'll almost certainly want for any serious business reporting. It installs as a system service, meaning it runs in the background on a server or computer, completely independent of any logged-in user.

• Who it's for: Teams, departments, and entire organizations. It's built for collaboration and automation.
• How it works: It runs 24/7 on a dedicated, always-on machine (ideally a server). Multiple users can be granted permission to use the gateway to connect their own reports to shared data sources.
• The main benefit: It’s centralized and shareable. An administrator can set up one gateway and add data source connections (like the main company SQL database), and then grant permissions to the marketing team, the sales team, and the finance team to use that single gateway for their reports. This enables scheduled, automatic data refreshes powering everyone's dashboards.

Our Recommendation: Always choose Standard Mode unless you have a very specific, temporary, individual use case. This article will focus on setting up the Standard Mode gateway.

Step-by-Step: Installing the On-Premises Data Gateway

The installation process is straightforward. Before you begin, make sure you're installing it on a computer that will always be running during your scheduled data refreshes and is on the same network as your data source.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Prerequisites You'll Need

• A Power BI Pro or Premium account.
• Local administrator rights on the computer where you'll be installing the gateway.
• A server or machine that meets the minimum requirements (check the official Microsoft documentation for the latest specs, but generally any modern Windows machine will work).

1. Download the Gateway Installer

First, head to the official Power BI Gateway download page. Click the download button to get the latest version of the installer file.

2. Run the Installer

Once downloaded, run the executable file. You’ll be greeted with a setup wizard.

• Accept the terms of use.
• Choose an installation path (the default is usually fine).
• When prompted, be sure to select "On-premises data gateway (recommended)," which is the standard mode.

The installer will take a few minutes to copy the necessary files to your machine.

3. Sign In with Your Power BI Account

Once installation is complete, you'll be prompted to sign in. Use the same email address and password you use to log into the Power BI service online. This links the gateway software on your local machine to your specific Power BI environment in the cloud.

4. Configure and Register the Gateway

This is the most critical step. You'll need to choose "Register a new gateway on this computer."

• Gateway Name: Give your gateway a descriptive name, like "Marketing Department SQL Gateway" or "CompanyMain Sales Server." This is how you'll identify it later in the Power BI service.
• Recovery Key: You'll be asked to create and confirm a recovery key. DO NOT lose this key. Write it down and store it in a secure password manager. This key is your only way to restore the gateway on a new machine, take over ownership, or change its credentials if you ever get locked out. If you lose it, you will have to create a new gateway from scratch and reconfigure all your data sources.

After you confirm your recovery key, the configuration is complete. You'll get a confirmation screen showing your gateway is online and ready to be used.

Adding a Data Source to Your Gateway

Your gateway is installed, but it doesn't know what data to fetch yet. The next step is to tell Power BI about your local data source and link it to the gateway.

1. Go to the Power BI Service: Log in to your Power BI account at app.powerbi.com.
2. Access Gateway Settings: In the top-right corner, click the gear icon for Settings and select "Manage connections and gateways."
3. Add a New Connection: At the top of the Connections page, click the "+ New" button. This will open a form to configure your internal data source.
4. Fill in the Connection Details:
5. Create and Test: Click "Create." Power BI will use the gateway to try and connect to your data source with the details you provided. If successful, you’ll see a green "Connection successful" message.

Congratulations! You've now connected your on-premises data source to the Power BI cloud.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Using Your Connection for Scheduled Refreshes

The final piece of the puzzle is using this new connection to keep your reports updated. The process works like this:

1. You build your report in Power BI Desktop, connecting directly to the on-premises database there.
2. You publish that report to the Power BI Service.
3. In the service, go to your workspace, find the dataset for the report you just published, and click the three dots to open its Settings.
4. Expand the "Gateway and cloud connections" section. Here, you will see your dataset's on-premises connection listed. Use the dropdown to map it to the gateway connection you created earlier.
5. Once mapped, you can scroll down to the "Scheduled refresh" section, enable it, and set a schedule (e.g., daily at 8:00 AM).

Now, at the scheduled time, Power BI will send a request to your gateway, which will gather the latest data from your local server and push it to your online dataset, keeping your dashboards perfectly up-to-date without any manual work.

Final Thoughts

Setting up a Power BI Gateway is a foundational step for any organization wanting to blend the security of on-premises data with the analytical power of the cloud. Following these steps helps you install the service, register your data source, and configure automated refreshes, turning your static reports into dynamic, data-driven tools for your entire team.

The manual process of installing gateways, configuring server details, and managing credentials highlights just how much effort it can take to prepare your data for analysis. We designed Graphed to remove this complexity. Instead of wrestling with installers and technical settings, you use one-click integrations to connect your marketing and sales platforms in seconds. You can instantly create real-time dashboards just by describing what you want to see, letting you focus on insights instead of infrastructure.