How to Use Personal Gateway in Power BI

You’ve spent hours in Power BI Desktop perfecting a report connected to a local Excel file on your C: drive, but once published, the data is just a static snapshot. This guide demystifies the Power BI Personal Gateway, showing you how it acts as a secure bridge to your on-premises data. We’ll cover what it is, when to use it, and provide a full step-by-step walkthrough to get you installing, configuring, and scheduling your first automated data refresh.

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 You Need One)

Power BI is a cloud-based service, meaning your reports and dashboards live on Microsoft’s servers. This is perfect for connecting to cloud data sources like SharePoint, Salesforce, or Google Analytics. But what about data that isn’t in the cloud? Think about that sales tracking Excel file on your laptop, a CSV download in your Downloads folder, or a local SQL Server database in your office.

These are called on-premises data sources. The Power BI Service, being in the cloud, has no way to see or access a file sitting on your personal computer’s hard drive. It can’t bridge that gap on its own for security and technical reasons. That's where a gateway comes in.

A Power BI Gateway is a secure piece of software you install on a local computer. It acts as a controlled tunnel or a "bridge," allowing the Power BI Service in the cloud to safely send queries to your on-premises data source and receive refreshed data back. It’s the essential middleman that makes automated refreshes possible for local data.

Microsoft offers two main types of gateways, and choosing the right one is your first important step.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Personal Gateway vs. Standard Gateway: Which One Is for You?

When you download the gateway installer, you'll have to choose between two very different modes: Personal Mode and Standard Mode. While they share a similar purpose, they are designed for vastly different scenarios.

Personal Mode Gateway

This is the gateway for the individual user. Think of it as your own personal data bridge that only you can use.

• How it works: It runs as a regular application on your computer, under your user account. It doesn't require administrator privileges to install.
• Best for: Individual analysts, Power BI learners, or anyone working on a solo project using local files like Excel, CSV, or Access. It lets you import data and set up scheduled refreshes for your own reports.
• Major Limitation: The gateway is only active when your computer is on, awake, and connected to the internet, and when you are logged in. If you close your laptop for the weekend, any scheduled refreshes will fail.

Standard Mode Gateway (On-premises data gateway)

This is the enterprise-grade solution designed for teams and organizations.

• How it works: It runs as a system service on a server (or an always-on computer). It’s designed to be shared by multiple users and is typically set up and managed by an IT department.
• Best for: Teams of content creators, organizational departments, and connecting to enterprise-level on-premises databases (like SQL Server, Oracle). It supports more complex connection methods like DirectQuery and Live Connection in addition to Import mode.
• Major Benefit: Since it runs as a service on a server, it's always on. This makes it a reliable and scalable solution for critical business reports that multiple people depend on.

For our purposes, we'll focus entirely on the Personal Mode Gateway - the perfect starting point for most individual analysts looking to automate their local file refreshes.

Step-by-Step Guide: How to Install and Configure the Personal Gateway

Getting the gateway set up is a straightforward process. Just follow these steps carefully.

Step 1: Download the Gateway

First, you need to grab the installer from the Power BI Service.

1. Log into your Power BI account at app.powerbi.com.
2. In the top-right corner of the screen, look for the download icon (an arrow pointing down into a bracket).
3. Click it and select Data Gateway from the dropdown menu.
4. This will take you to a download page. Click the "Download standard mode" button. Don't worry about the name, the installer contains both Standard and Personal modes.

The installer file will download to your computer.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Run the Installer and Select Personal Mode

Once downloaded, locate the file (e.g., GatewayInstall.exe) and double-click it to start the installation process.

1. Accept the terms of use and click Install.
2. The installer will ask for the email address you use for Power BI. Enter it and click Sign in. You'll work through the familiar Microsoft login prompts.
3. Now for the most important step: the setup wizard will present you with two options. You must select On-premises data gateway (personal mode). This tells the wizard you're setting up the gateway just for yourself.
4. Click Next. The installer will finalize the configuration.

Step 3: Confirm the Installation

After clicking next, you'll see a confirmation screen telling you that "The gateway is online and ready to be used." That's it! The gateway application is now running on your computer. You'll see an icon for it in your system tray, where you can access its status and settings if needed, but most of the work from here on out happens in the Power BI Service.

Connecting a Data Source and Scheduling a Refresh

With the gateway installed, you’re ready for the payoff: automating a refresh.

Step 1: Publish Your Report to Power BI Service

Let's assume you have a Power BI Desktop report (.pbix file) that connects to a local data source. For this example, let’s say it’s an Excel workbook named Monthly_Sales_Data.xlsx saved on your desktop.

1. Open the report in Power BI Desktop.
2. On the Home tab, click Publish.
3. Select a workspace to publish it to (e.g., "My workspace").
4. Upon success, you will get a link to open the report in the Power BI Service.

When you publish a report with a local source, Power BI also creates a corresponding dataset in the service - this is what we need to configure.

Step 2: Configure the Data Source Credentials

In the Power BI Service, you need to tell the gateway how to access your local Excel file.

1. Navigate to the workspace where you published your report.
2. Find the dataset associated with your new report. Datasets have an orange icon. Hover over it, click the three-dot menu (...) and select Settings.
3. On the Settings screen, expand the Gateway and cloud connections section.
4. You should see your personal gateway listed as running. Power BI automatically maps your on-premises data source to your new gateway. Below the gateway information, you’ll see the actual data source connection (e.g., reflecting the file path C:\Users\Username\Desktop\Monthly_Sales_Data.xlsx).
5. It will show a small warning icon and say Credentials are not configured. This is expected. We need to store secure credentials for the gateway to use.
6. Click on Edit credentials. For a local file, you'll usually use Windows Authentication. You will enter your full Windows account username (often email format, like username@yourcompany.com) and password. These are the same credentials you use to log into your computer.
7. Once entered, click Sign In. If successful, you'll see a green checkmark saying the connection is ready.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Schedule the Refresh

Now for the final piece. In the same Settings screen, scroll down and expand the Scheduled refresh section.

1. Toggle the switch to turn it On.
2. Choose your desired refresh frequency, like Daily or Weekly.
3. Set the timezone your schedule will run on.
4. Click Add another time and pick the time(s) of day you want the refresh to happen. With a Power BI Pro license, you can schedule up to 8 times per day.
5. Finally, make sure to check the box underneath "Send refresh failure notifications to me." This is crucial for knowing if something goes wrong.
6. Click Apply.

And you're done! At the next scheduled time, as long as your computer is on and online, the Power BI Service will send a request through your gateway, fetch the latest data from your Excel file, and update your report visuals automatically.

Best Practices and Common Issues

To avoid frustration, keep these points in mind when using a personal gateway:

• Your PC must be ON. This is the golden rule of personal gateways. The computer where the gateway is installed must be powered on and connected to the internet at the scheduled refresh time. If it's asleep, hibernating, or offline, the refresh will fail.
• Keep Gateway Software Updated. Microsoft regularly updates the gateway software. Keep it current to ensure compatibility and security.
• Stable File Paths are Essential. The connection is tied to the exact file path you used in Power BI Desktop (e.g., C:\_Data\Reports\Report.xlsx). If you move or rename the file, the refresh connection will break.
• Diagnosing Failed Refreshes. If a refresh fails, Power BI will email you an alert. You can also view the refresh history in the dataset settings. Common causes include the computer being off, a changed Windows password messing up credentials, or a network firewall issue blocking the connection.

Final Thoughts

Setting up a Personal Gateway is a liberating step for any Power BI user working with local data. By acting as that secure bridge, it transforms a static, manually-updated report into a dynamic business tool that automatically keeps itself current. While standard gateways are best for teams, the personal gateway gives individual creators the power of automation right from their own machines.

While a gateway is essential for connecting to on-premises sources, an even bigger challenge for many marketing and sales teams is the manual hassle of pulling reports from dozens of different cloud platforms. Bringing data together from apps like Google Analytics, Shopify, Facebook Ads, and HubSpot often involves endless CSV downloads and spreadsheet work. This is the exact friction we built Graphed to eliminate. We connect directly to your cloud data sources so you can have a real-time, consolidated view of performance without any gateways or complex setups. Instead of building reports manually, you just describe what you want to see, and our AI analyst creates the dashboard for you instantly.