How to Check if Power BI Gateway is Running

Nothing brings your data analysis to a halt faster than a Power BI report that refuses to refresh. When your dashboards are showing stale data, one of the most common culprits is the On-premises Data Gateway. This article will show you three easy ways to check if your Power BI gateway is running and walk you through the most common fixes to get your data flowing again.

Graphed

Still Building Reports Manually?

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

Watch the Demo

What is the Power BI Gateway? A Quick Refresher

Before diving into the "how," let's quickly clarify the "what." The Power BI On-premises Data Gateway is a small but mighty piece of software that acts as a secure bridge. It connects data sources that live on your local computer or a private company network - like a local SQL Server database, an Excel file on your C: drive, or an Analysis Services model - to the Power BI cloud service.

Without this bridge, Power BI can't access that on-premises data to refresh your reports and dashboards. If the gateway service stops running, the bridge is down. Scheduled refreshes will fail, and your stakeholders will be looking at outdated information, which can lead to poor decisions. Ensuring the gateway is online is fundamental to maintaining a reliable and trustworthy reporting environment.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 1: Using the On-Premises Data Gateway App

The most direct way to check the gateway's status is by using the application itself on the machine where it’s installed. This should be your first port of call for any troubleshooting.

Step-by-step instructions:

1. Navigate to the computer or server where you installed the gateway. This could be your own PC or a dedicated server machine.
2. Open the Windows Start Menu.
3. Start typing "On-premises data gateway" and select the application when it appears.

Once the app launches, you'll see a status screen right away. This screen gives you an immediate verdict:

• If it's working: You will see a green checkmark and a clear message stating, "The on-premises data gateway is online and ready to be used." This means the bridge is up, and Power BI can communicate with it.
• If it's not working: You might see a red 'X' or a message indicating that the gateway is offline or misconfigured. This screen is also where you'd sign in with your Power BI account if the connection has been lost.

This method is foolproof for confirming the local status. If it shows everything is running here, but your reports still aren’t refreshing, the problem likely lies elsewhere, such as with data source credentials or network issues.

Method 2: Checking Gateway Status in the Power BI Service (Online)

What if you aren't near the machine where the gateway is installed? You can easily check the gateway’s status from anywhere by logging into the Power BI web portal. This is perfect for a quick spot-check from afar.

Step-by-step instructions:

1. Open your web browser and navigate to https://app.powerbi.com.
2. Log in with your Power BI account credentials.
3. In the top-right corner of the screen, click the Settings gear icon.
4. From the dropdown menu, select Manage connections and gateways.

This will take you to a new page. Click on the On-premises data gateways tab. Here, you'll see a list of all gateways associated with your account. Next to each gateway name, there is a "Status" column with a colored circle:

• Green Circle: This means the gateway is online and Power BI can reach it.
• Orange/Yellow Circle: This often indicates a potential issue, such as the gateway being unreachable or running an outdated version.
• Red Circle or a warning icon: This signals a clear problem. The gateway is offline and completely unreachable by the Power BI service.

Hovering over the status indicator sometimes provides more information about the problem. This remote check is invaluable for quickly diagnosing if an issue is gateway-related without needing physical access to the server machine.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 3: Checking the Windows Service Directly

For those who want to look a little more under the hood, you can verify that the underlying Windows service for the gateway is active. Every application like the Power BI gateway runs as a "service" in the background of the Windows operating system. If this service gets stopped for any reason (like a system error or a pending Windows update), the gateway goes down.

Step-by-step instructions:

1. On the gateway machine, press the Windows Key + R to open the Run command box.
2. Type services.msc into the box and press Enter. This will open the Windows Services manager.
3. The services are listed alphabetically. Scroll down to find the one named On-premises data gateway service.
4. Look at the Status column for this service. It should clearly say "Running."

If the status column is blank or says "Stopped," you've found the root of the problem. To fix it, simply right-click on "On-premises data gateway service" and select Start. The status should change to "Running" within a few seconds. If it's already running but you suspect an issue, you can also use the Restart option here, which is a great troubleshooting step.

What to Do If Your Gateway Isn't Running

Okay, so you've confirmed the gateway is offline. What's next? Here are a few common scenarios and their straightforward solutions.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Problem: The Gateway Service Won't Start from services.msc

You tried starting the service, but it either stopped immediately or gave you an error. Here’s what to check:

• Restart the Machine: The oldest trick in the IT book is often the most effective. A simple restart can resolve temporary glitches or complete pending system updates that might be preventing services from starting properly.
• Check the Service Account Credentials: In corporate environments, the gateway service might be configured to run under a specific user account (not the default). If that account's password has expired, the service will fail to start. You can check this by right-clicking the service in services.msc, going to Properties > Log On. If you suspect a password issue, you'll need to update it here.
• Update or Reinstall the Gateway: Gateway software, like any other, needs to be updated. An outdated version can lose compatibility with the Power BI service. If all else fails, a clean reinstallation might be necessary to fix a corrupted installation. You can always download the latest version from Microsoft.

Problem: The Gateway is Running, but Reports Still Fail to Refresh

This is a frustrating one. The gateway apps and services manager all say everything is fine, yet your data remains stale. The problem isn't with the bridge itself, but with what's trying to cross it.

• Check Data Source Credentials: Go back to Manage connections and gateways in the Power BI service. Click on your gateway, and you will see all the data sources using it. If any of them have a warning icon, it means the stored credentials (username/password or key) for that specific data source are invalid and need to be updated.
• Verify Network Connectivity: Make sure the gateway machine can actually reach your data source. For example, can it connect to the SQL server? Has a firewall rule recently changed? And don't forget the basics - is the machine connected to the internet? Simple connectivity issues are a frequent cause of "unexplained" refresh failures.
• Review the Gateway Logs: If you're really stuck, the gateway app itself has a tool for this. Open the On-premises data gateway app, go to the Diagnostics tab, and click "Export logs." This creates a zip file with detailed log files that can contain specific error messages pointing to the exact cause, which is extremely helpful for more complex issues.

Final Thoughts

Keeping your Power BI reports fresh is a vital task, and a functioning gateway is the linchpin. By checking the gateway app, the Power BI service portal, or the Windows Services manager, you can quickly diagnose whether your gateway is the source of a refresh issue and take targeted steps to resolve it.

All this troubleshooting around configuring gateways, managing service accounts, and diagnosing refresh failures is a perfect example of the friction modern data reporting tools often create. It’s why we built Graphed. We believe getting insights from your data shouldn't require you to become a part-time IT admin. Instead of configuring complex data bridges for all your sources, we offer one-click integrations that just work. You can create live, interactive dashboards by simply asking for them in plain English, allowing you to get back to analyzing data instead of fixing broken connections.