Data gateway setup in Power BI - Step-by-Step Guide

Introduction

A data gateway lets Power BI connect securely to your on-premises data sources. It solves the problem of refreshing reports and dashboards with up-to-date data from local databases or files without moving data to the cloud.

When your sales report needs daily updates from a local SQL Server database.

When you want to refresh Power BI dashboards using Excel files stored on your company network.

When your organization keeps data behind a firewall and you want secure cloud access.

When you schedule automatic data refreshes but your data source is not in the cloud.

When multiple users need to share and refresh reports connected to on-premises data.

Steps

Step 1: Download the Power BI Gateway installer

- Power BI website under Data Gateway section

The installer file is saved on your computer

💡 Choose the standard mode for most scenarios

Step 2: Run the installer

- Your computer's file explorer

The gateway setup wizard opens

💡 Run as administrator for smooth installation

Step 3: Sign in with your Power BI account

- Gateway setup wizard sign-in screen

Your account is linked to the gateway

💡 Use the same account you use for Power BI service

Step 4: Choose the gateway mode

- Gateway setup wizard mode selection

Gateway is configured as either personal or standard

💡 Standard mode supports multiple users and data sources

Step 5: Register the gateway with a name and recovery key

- Gateway setup wizard registration screen

Gateway is registered and ready to connect

💡 Save the recovery key safely for future use

Step 6: Open Power BI service and go to Manage Gateways

- Power BI service settings menu

You see your registered gateway listed

💡 Here you can add data sources and manage users

Step 7: Add a new data source to the gateway

- Manage Gateways pane in Power BI service

Data source is linked to the gateway for refresh

💡 Enter correct connection details and credentials

Before vs After

Before

Power BI reports cannot refresh data from local databases or files automatically

After

Power BI reports refresh automatically using the configured data gateway connected to on-premises data

Settings Reference

Gateway mode

📍 Gateway setup wizard

Choose how the gateway will be used and who can access it

Default: Standard mode

Recovery key

📍 Gateway setup wizard registration screen

Protects your gateway and allows recovery if needed

Default: None

Data source credentials

📍 Manage Gateways pane in Power BI service

Allows the gateway to connect securely to your data source

Default: Depends on data source

Common Mistakes

Installing gateway but not registering it with your Power BI account

The gateway won't connect to Power BI service and cannot refresh data

Complete the registration step by signing in with your Power BI account during setup

Using personal mode gateway for multiple users

Personal mode supports only one user and limited data sources

Use standard mode gateway for team or organizational use

Entering incorrect credentials for data source in Manage Gateways

Gateway cannot connect to data source and refresh fails

Verify and enter correct authentication details matching your data source

Summary

A data gateway connects Power BI service to your local data securely for automatic refresh.

Install and register the gateway with your Power BI account using the setup wizard.

Use standard mode for shared use and configure data sources with correct credentials.