How to Create a Gateway Connection in Power BI Ser...

anmolmalviya05 · ‎02-12-2026

When working with Power BI, one of the most common questions beginners ask is:

“Why is my dataset not refreshing after publishing to Power BI Service?”

In most cases, the answer is simple, you need a Power BI Gateway.

In this blog, you’ll learn:

What a Power BI Gateway is
Why it is required
Difference between Personal and Standard mode
Step-by-step process to install and configure a Gateway
How to map your dataset and refresh it successfully

Why Do We Need a Gateway in Power BI Service?

Let’s understand this with a real-world scenario.

You create a Power BI report using:

SQL Server
Excel file stored on your local machine

You publish this report to Power BI Service (Cloud)

Now comes the problem 👇

Your data source is on your local system, but Power BI Service runs in the cloud.

This setup is called On-Premises Data Source.

👉 To allow Power BI Service to securely access your local data, we need a bridge between:

Local system (On-Premises)
Cloud (Power BI Service)

That bridge is called a Power BI Gateway.

What Is a Power BI Gateway?

A Power BI Gateway:

Acts as a secure bridge between on-premises data and Power BI Service
Enables manual refresh and scheduled refresh
Transfers data securely from local system to cloud

Without a gateway:

❌ Dataset refresh will fail

❌ Schedule refresh cannot be enabled

Error You See Without Gateway

If you try refreshing a dataset without configuring a gateway, Power BI shows an error like:

“Refresh failed because this semantic model requires a gateway.”

This confirms that a gateway is mandatory for your data source.

Types of Power BI Gateway

Power BI provides two gateway modes:

🔹 1. Personal Mode

Used by individual users
Cannot be shared
Suitable for personal projects only

🔹 2. Standard Mode (Recommended ✅)

Can be shared with multiple users
Used in organizations
Can also be used for personal projects

👉 Best practice: Always use Standard Mode

Step-by-Step: Install Power BI Gateway (Standard Mode)

Step 1: Go to Power BI Service

Open your workspace
Click on Download (top navigation bar)
Select Data Gateway

Step 2: Download Standard Mode

Choose Download Standard Mode
Wait for the installer to download

Step 3: Install the Gateway

Choose installation directory
Accept terms & conditions
Click Install

Once installed, you’ll see:

✅ Installation was successful

Step 4: Sign In

Use the same email ID you use for Power BI Service
Click Sign In

Step 5: Register the Gateway

You’ll see two options:

Register a new gateway
Migrate / Restore an existing gateway

👉 Select Register a new gateway on this computer

Step 6: Configure Gateway Details

Give your gateway a name
Set a Recovery Key (very important)

⚠️ Keep the recovery key safe, it’s required if you move the gateway to another system.

Click Configure.

🎉 Your gateway is now online and ready to use.

Configure Gateway Connection in Power BI Service

Now let’s connect your dataset with the gateway.

Step 1: Open Dataset Settings

Go to your workspace
Click Settings (Of report)
Open Gateway and Cloud Connections

You’ll see:

❌ Gateway not configured correctly

Step 2: Add Data Source to Gateway

Click the right arrow
Select Add to Gateway
Create a new connection

Provide:

Connection Name (e.g. SQL Server Connection)
Server Name
Database Name
Authentication → Basic
SQL Server Username & Password
Privacy Level → Organizational

Click Create

Step 3: Map Dataset to Gateway

Go back to Gateway and Cloud Connections
Now you’ll see Maps to option
Map the dataset to the newly created SQL Server connection
Click Apply

✅ Mapping completed successfully

Refresh Dataset Using Gateway

Now your dataset is fully connected.

You can:

🔄 Trigger Manual Refresh
⏰ Configure Schedule Refresh

To test:

Go to workspace
Click Refresh
You’ll see the refresh in progress

Once completed, your dataset is refreshed successfully 🎯

Key Takeaways

✔ Gateway is mandatory for on-premises data

✔ Standard mode is recommended

✔ Gateway acts as a secure bridge

✔ Required for manual & scheduled refresh

✔ Recovery key must be stored safely

Frequently Asked Questions (FAQs)

❓ Do I need a gateway for SharePoint or OneDrive?

No. Cloud sources do not require a gateway.

❓ Can I use one gateway for multiple datasets?

Yes. Standard mode gateway can be shared.

❓ What happens if my system is turned off?

Refresh will fail because the gateway is offline.

❓ Can I install gateway on a server?

Yes. This is the recommended approach for production.

🔚 Stay Connected with Power BI Corner

If you found this blog helpful and want to deeply understand Power BI and Microsoft Fabric, make sure to stay connected with me across platforms:

🔹 YouTube:

👉 Check out Power BI Corner for practical tutorials and real-world projects

https://www.youtube.com/@PowerBICorner

🔹 LinkedIn:

👉 Connect with me on LinkedIn for daily Power BI & Fabric insights

https://www.linkedin.com/in/anmol-malviya/?originalSubdomain=in

🔹 Telegram Community:

👉 Join the Power BI Corner Telegram group for discussions & updates

https://t.me/+Il8fNsHm2ng3YmNl

🔹 WhatsApp Group:

👉 Be part of the Power BI learning community on WhatsApp

https://chat.whatsapp.com/KqsU8HUXcsaIoUEyq0zCIq

🚀 Keep learning. Keep building. Power BI mastery starts here.

AhmedMamdoh · ‎02-21-2026

Good

_power_bi · ‎03-06-2026

I have an existing connection. It is for an on-prem SQL Server. It contains the server and database name. Authetication type is Windows. The privacy policy is Organization.

I made a new report and published to the service. It uses all the exact same connections. When I go to refresh, I have to select from the connections and the existing connection I have already is not in the dropdown.

I check everything including the case on the server and database names. They are the same. Why does Power BI not let me use the existing connector? We have many connectors and I do cleanup on them to ensure we don't have any that are not in use. So to keep making new connectors to the same source seems like bad practice. I have other connectors that I use and they populate in the dropdown. Seems like a bug honestly.