How to Update Power BI Gateway

Keeping a Power BI On-premises data gateway updated is essential for maintaining a secure and efficient connection to your local data sources. This guide walks you through the straightforward process of updating your gateway, with tips for troubleshooting common issues along the way.

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 Update It?

In simple terms, the On-premises data gateway acts as a secure bridge between your data that lives locally on your network (like in a SQL Server database) and the Power BI service in the cloud. Without it, your cloud-based Power BI reports wouldn't be able to access or refresh data from your on-site sources. It’s the gatekeeper that safely manages data traffic without exposing your entire database to the internet.

But why does it need frequent updates? Microsoft releases updates for the gateway almost every month, and staying current isn't just a recommendation - it's a critical part of data infrastructure management.

• Security Patches: This is the biggest reason. Every update includes the latest security enhancements to protect your data bridge from potential vulnerabilities. An outdated gateway can become a weak link in your security chain.
• New Features and Connectors: Power BI is constantly evolving. Updates often include support for new data sources, enhanced performance for existing connectors, and new features that improve how the gateway operates.
• Performance Improvements: Updates often contain optimizations that can make data refreshes faster and more reliable. Quicker refreshes mean your reports are ready when you need them.
• Bug Fixes: If you've been running into strange errors or connection issues, an update often contains the fix. Staying behind on versions means you might be dealing with a problem that has already been solved.

Skipping updates can lead to poor performance, broken refreshes, and - most importantly - security risks. Microsoft only supports the last six versions of the gateway, so falling too far behind can leave you without support if something goes wrong.

Before You Update: A Pre-Flight Checklist

Just like any software update, a little preparation can save you a big headache later. Before you click "install," run through this quick checklist.

1. Check System and Power BI Requirements

Make sure the machine running the gateway still meets the minimum system requirements. These rarely change dramatically, but it's good practice to confirm. You can find the latest requirements on the official Microsoft Power BI gateway download page. More importantly, check for any announcements about major changes in the latest Power BI release notes that might affect gateways.

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. Notify Your Users

The update process itself is fast (usually just a few minutes), but during that time, the gateway will be offline. This means any scheduled data refreshes will fail, and users trying to interact with reports that rely on a live connection to an on-premises source might see an error. Send a quick email or Slack message to your team letting them know you're performing gateway maintenance and that service will be briefly interrupted.

3. Pick the Right Time

To minimize disruption, schedule the update during a period of low activity. For many businesses, this might be early in the morning, late in the evening, or during a weekend. Avoid updating right before a major presentation or at the end of a fiscal quarter when report usage is at its peak.

4. Find Your Recovery Key

While the update process is typically smooth and preserves your settings, it's always wise to have your gateway recovery key handy. You were prompted to save this key when you first installed the gateway. If for any reason you need to restore your gateway on a new machine, this key is non-negotiable. You can find it in the "Recovery Key" section of the On-premises data gateway application on the server.

The Step-by-Step Guide to Updating Your Gateway

With your prep work done, the update itself is actually the easy part. The installer intelligently detects your existing installation and handles the rest.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 1: Download the Latest Gateway Installer

First, you need to get the latest version. Head over to the official Power BI gateway download page. The page will automatically suggest the standard mode gateway, which is what you want for Power BI service connectivity. Download the installer file.

Step 2: Run the Installer on the Gateway Machine

You must run the update on the same server or computer where your gateway is currently installed. If it’s on a company server, you may need to remote desktop into it. Navigate to the downloaded file and run the installer. You'll likely need administrative permissions on the machine to proceed.

Step 3: Accept the Terms and Start the Process

The installer window will appear. Accept the license terms, and then the installer will automatically detect that you have a previous version installed. It will present you with an "Update" button instead of an "Install" button. Click Update to begin the process.

The update will take a few minutes. It will stop the current gateway service, replace the old files with the new ones, and then restart the service.

• Important Note: You do not need to uninstall the old gateway first! The updater is designed to work on top of your existing installation.

Step 4: Sign In to Your Power BI Account

Once the file installation is complete, you'll be prompted to sign in. Use the same Power BI account email address that you used to originally configure the gateway. This is what links the gateway software on your server to your Power BI workspace in the cloud.

Step 5: Confirmation and Finalization

After a successful sign-in, you'll see a confirmation screen letting you know the gateway is online and ready to be used. The update is now complete! You can open the On-premises data gateway application and check the bottom of the window to verify that the new version number is displayed.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Post-Update Checks: Making Sure Everything Works

Your gateway is updated, but it's always a good idea to perform a few quick checks to ensure a seamless transition.

1. Check an Existing Data Source: In the gateway application, go to the "Data Sources" tab. Pick one of your configured sources and run a "Test Connection" to confirm it can still communicate successfully with the underlying database or file.
2. Verify Status in Power BI Service: Log into app.powerbi.com and navigate to Settings > Manage connections and gateways. Find your gateway in the list and ensure it shows an "Online" status.
3. Manually Trigger a Report Refresh: Go to a workspace that depends on the gateway. Find a semantic model (formerly dataset) that uses an on-premises data source and initiate a manual refresh. If it completes successfully, you're in the clear.

Troubleshooting Common Update Issues

Although the update process is generally stable, you can occasionally run into minor roadblocks. Here are a few common problems and how to solve them.

Problem: The update fails to install.

• Run as Administrator: The most common cause is a permissions issue. Right-click the installer file and select "Run as administrator."
• Antivirus or Firewall: Sometimes, security software can block installers. Temporarily disable your antivirus or check your firewall logs to see if it's blocking the connection, and if so, add an exception for the gateway service.

Problem: The gateway appears "Offline" in Power BI Service after the update.

• Restart the Service: First, try restarting the service manually. Open the On-premises data gateway application on your server. Go to the "Service Settings" tab and click "Restart now." Wait a minute and check the status in Power BI Service again.
• Check the Server's Network Connection: It sounds basic, but ensure the server itself hasn't lost its internet connection.

Problem: Data refreshes are failing with credential errors.

• Re-enter Credentials: On rare occasions, an update can affect stored credentials. In Power BI Service, go to the gateway management page, find the data source that is failing, and re-enter and verify the credentials used to connect to it.

Final Thoughts

Keeping your On-premises data gateway updated is a simple but vital maintenance task for any organization using Power BI with local data. By following a routine checklist and the straightforward update process, you can ensure your data connections remain secure, reliable, and performant, giving you peace of mind and your team access to timely insights.

Managing gateways is part of the territory when bridging on-premises data with the cloud, but sometimes you just want data analytics to be simpler. With the explosion of cloud-based marketing and sales platforms, we believe connecting data shouldn't require installing server-side software at all. We built Graphed to remove this kind of friction, especially for non-technical teams. Instead of managing gateways, you just connect cloud sources like SharePoint, Google Analytics, Shopify, and dozens of others in a few clicks to get back to what matters - building real-time reports with simple, natural language.