How to Install Personal Gateway in Power BI

You’ve built a fantastic dashboard in Power BI Desktop using an Excel file saved on your computer. It’s clean, insightful, and ready to share. You publish it to Power BI Service, but then you hit a common roadblock: the data isn’t updating. The only way to see the latest numbers is to manually republish it every single day. This article will show you how to fix that by installing and configuring the Power BI Personal Gateway to enable scheduled, automatic data refreshes.

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? The Two-Way Bridge for Your Data

Think of a Power BI Gateway as a secure bridge between your data sources that live inside your company’s network or on your computer (on-premises) and the cloud-based Power BI Service. Without this bridge, Power BI Service has no way of knowing when you’ve updated that local Excel file or SQL database.

Microsoft offers two versions of the gateway, and choosing the right one is critical. While both are downloaded from the same installer, they function in very different ways.

On-Premises Data Gateway (Standard Mode)

This is the heavy-duty, enterprise-grade version. It’s designed to be installed on a dedicated, always-on server and can be shared by multiple users across your organization. It’s the go-to choice for IT departments and dedicated data teams.

• For Multiple Users: A single Standard Gateway installation can be used by many developers and analysts.
• Runs as a Service: It runs in the background on a server, meaning it works even if no one is logged into the machine.
• Supports More Connection Types: It handles not just scheduled data refreshes (Import mode) but also live connections (DirectQuery and Live Connection) to sources like SQL Server Analysis Services (SSAS).

In short, Standard Mode is for collaborative, always-on, enterprise-level data connections.

Graphed

Still Building Reports Manually?

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

Watch the Demo

On-Premises Data Gateway (Personal Mode)

Often referred to simply as the "Personal Gateway," this version is simpler, designed for a single user, and doesn't require a dedicated server. It’s built for individual analysts, Power BI learners, or anyone who doesn't have administrative rights to install software on a shared server.

• For a Single User: Only you can use your Personal Gateway to refresh your datasets. It cannot be shared.
• Runs as an Application: It runs as an application on your own computer. This means your computer must be turned on and you must be logged in for the data refresh to work. If you shut down your PC for the day, the scheduled refresh will fail.
• Supports Scheduled Refresh Only: Its primary purpose is to refresh datasets that use Import mode. It does not support DirectQuery or Live Connection.

In short, Personal Mode is perfect for individual users who need to automate refreshes for datasets connected to local files like Excel, CSV, or a local database.

When Should You Use the Personal Gateway?

The Personal Gateway is the perfect solution in several common scenarios. If any of these sound like you, you're in the right place:

• You Are a Solo Analyst: You are the only person who manages your dashboards and data sources. Your primary source is an extensive Excel file or a small database on your local machine that you update regularly.
• You Are Learning Power BI: You're just getting started and want to understand the full workflow, from report creation to scheduled refreshes, without needing IT involvement or a server.
• You Have Limited Permissions: You don't have the administrative rights needed to install software on your company's servers, but you can install applications on your own work computer.
• Your Goal is Automation: Your main goal is to stop the manual process of opening Power BI Desktop and clicking "Publish" every morning. You just need to import the new data on a schedule.

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

Installing the gateway is straightforward. Follow these steps carefully to ensure everything is configured correctly.

Step 1: Download the Gateway

First, you need to download the installer from the official Power BI website. You can find it by navigating to the Power BI Gateway page or by clicking the download arrow in the top-right corner of the Power BI Service and selecting "Data Gateway."

Click the Download standard mode button. Don't worry about the name, this single installer contains both Standard and Personal modes.

Step 2: Run the Installer and Choose Personal Mode

Once the download is complete, run the executable file. You’ll be presented with a few initial screens for location and terms of service. After accepting, you will reach the most important screen:

You will be asked to choose which gateway mode to install.

Select On-premises data gateway (personal mode). This tells the installer to set up the gateway to run under your specific user account for refreshing imported data.

Click "Next" to continue the installation.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Sign In to Your Power BI Account

The installer will now prompt you to sign in. This is a crucial step.

You MUST sign in with the exact same account you use for the Power BI Service (app.powerbi.com).

This action links the gateway running on your computer directly to your Power BI account in the cloud. If you use a different account, Power BI Service won't be able to find and use your gateway.

Step 4: Installation Confirmation

After a few moments, the installation will finish, and you’ll see a confirmation screen. It will show that the gateway is online and ready to be used. That’s it! The software is installed. Now, we just have to tell Power BI how to use it.

Connecting a Data Source in Power BI Service

With the gateway installed correctly, the final step is to configure your dataset in Power BI Service to use it.

Step 1: Go to Power BI Settings

In your browser, navigate to the Power BI Service. Click on the gear icon in the top-right corner and select Manage connections and gateways.

Step 2: Verify Your Gateway

On this page, you’ll see a tab labeled On-premises data gateways (personal). Click on it. You should see your Personal Gateway listed here with a green status indicator, confirming it’s connected to the service.

Step 3: Configure Your Dataset’s Connection

Now, we need to point your specific dataset to this gateway.

1. Navigate to the workspace where you published your report.
2. Hover over the dataset for that report (not the report itself) and click the three vertical dots (...) for more options. Select Settings.
3. In the Dataset settings, expand the Gateway connection section.
4. You should see the data sources from your file (e.g., the file path to your Excel sheet). To the right, you will see a notice that you're not connected through your newly installed personal gateway.
5. Click 'Add to gateway'.
6. You'll now be taken back to the manage gateways page again. This time a new window will pop up that lets you enter your sign-in credentials to your on-premises data source to create the connection with your gateway.
7. Enter the file path and login credentials for your on-premises data source when prompted. Usually, for files like Excel, you enter your Windows username and password of the computer that the file lives on.
8. Click create once you fill out your login info and you should be good to go.
9. Navigate back to your dataset in the workspace and click the more options link again followed by 'Settings'.
10. Then, expand the Gateway connection again to see that Power BI has automatically mapped your data source in the cloud with its connection on your on-premises gateway that you just created.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 4: Set Your Refresh Schedule

With the gateway connection established, you can now scroll down to the Scheduled refresh section in the same settings page. Toggle it on, and you can now set the frequency (daily, weekly) and the specific times you want Power BI to automatically refresh your data. You can even set up multiple refreshes per day.

Once you click "Apply," you’re all set. Power BI will now use your Personal Gateway to access the file on your computer and refresh the dataset according to your schedule.

Troubleshooting Common Personal Gateway Issues

Sometimes things don't go perfectly. Here are a few common issues and their solutions:

• Gateway is Offline: This is the most common problem. Remember, for the Personal Gateway to work, your computer must be on, connected to the internet, and you must be logged in to your Windows account. If your PC is asleep or shut down, the gateway cannot function, and the scheduled refresh will fail.
• Credential Errors: If the refresh is failing and mentioning credentials, go back to the dataset settings (under Gateway connection) and re-enter the credentials for your data source. This is especially common if you've recently changed your Windows password.
• Mismatched Power BI Desktop: Make sure you are using a recent version of Power BI Desktop. In some rare cases with specific drivers, a mismatch between a 32-bit driver and a 64-bit gateway can cause issues. Always use the 64-bit version of Power BI Desktop if possible.

Final Thoughts

The Power BI Personal Gateway is an essential tool for any individual analyst who wants to bridge the gap between their local data and the Power BI Service. By following the steps outlined above, you can confidently install, configure, and automate your reporting process, freeing you from tedious manual updates.

At Graphed, we believe getting insights shouldn't require navigating complex setup processes and installations just to keep your data current. That’s why we purpose-built our platform to connect to all your key cloud marketing and sales sources automatically. With Graphed, you create real-time, always-on dashboards by simply describing what you want to see in plain English. There are no gateways to install and no schedules to manage - just direct connections that stream live data, giving your team instant access to insights without the friction.