How to Create a Gateway Connection in Power BI Service (Complete Beginner Guide)

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

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.4

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

📘 Power BI Interview Preparation
👉 300+ Power BI Interview Questions with Answers
https://topmate.io/anmol_malviya/page/rRDZ0OuyvK

🎓 Udemy Courses
👉 Explore my Power BI & Analytics courses on Udemy
https://www.udemy.com/user/anmol-malviya-8/

📋 Free Resource
👉 Get a Free Power BI Interview Preparation Checklist
https://topmate.io/anmol_malviya/1620303?utm_source=public_profile&utm_campaign=anmol_malviya

📞 1-on-1 Guidance
👉 Want personalized help? Book a 1-on-1 call with me
https://topmate.io/anmol_malviya

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

Comments

Post a Comment

Popular posts from this blog

Microsoft Introduces DP-800: SQL AI Developer Associate Certification – Everything You Need to Know

Image
Artificial Intelligence is rapidly transforming the way modern data applications are designed. Organizations are increasingly integrating AI capabilities into their data platforms to enable intelligent search, automation, predictive analytics, and conversational experiences. To support this evolution, Microsoft has introduced a new certification: Microsoft Certified: SQL AI Developer Associate This certification is earned by passing the DP-800: Developing AI-Enabled Database Solutions exam, which is currently available in beta. In this blog, we will explore what this certification is about, who it is designed for, what skills it validates, and why it could become an important credential for modern SQL professionals. What is the DP-800 Certification? The DP-800: Developing AI-Enabled Database Solutions exam validates your ability to integrate Artificial Intelligence capabilities directly into SQL-based applications and databases . Traditionally, AI solutions required moving da...
Read more

Import Microsoft Planner Data into Power BI Using Power Automate and SharePoint

Image
  In this guide, we’ll cover how to bring task data from Microsoft Planner into Power BI for analysis, using Power Automate and SharePoint as intermediaries. Since Power BI currently lacks a direct Planner connector, Power Automate lets us fetch the data from Planner and save it to SharePoint as a JSON file, enabling Power BI to access it on a scheduled basis. Prerequisites Before you begin, ensure you have: Access to Microsoft Planner  – to view and retrieve Planner task data. Power Automate License  – access to create and run Power Automate flows. SharePoint Access  – a SharePoint site to store JSON files. Using SharePoint simplifies the setup, as it doesn’t require a premium Power BI or Power Automate license. Power BI Desktop  – to set up and configure the JSON data connection and publish the report. Microsoft 365 Account  – for authentication, as we’ll be connecting Power BI to SharePoint through your organization’s Microsoft 365 credentials. Step 1: S...
Read more

Displaying the Last 6 Months of Data Based on a Single Slicer Selection in Power BI

Image
  In this blog, we'll explore how to display the previous 6 months of data based on a single slicer selection in Power BI. Data Model Overview To achieve this, we create two relationships between the ‘Date’ table and the ‘Sales’ table. The active relationship uses order data, while the inactive relationship uses delivery data, as shown below:   Data Model Configuration:  We have configured the relationships so that the active relationship filters based on order data, and the inactive relationship filters based on delivery data. The Challenge The challenge is to figure out how to display data for different months using a slicer. In our case, the Year and Month slicer is based on the ‘Date’ table and is currently filtering only the selected months. This is fine for typical month-to-month selection, but we want to display the previous 6 months based on the selected month. The Solution To solve this, we will create an additional table that will contain the same month values a...
Read more