How to Configure Schedule Refresh in Power BI Service (Step-by-Step Guide)

Keeping your Power BI reports up to date automatically is critical once they are shared with business users. No one wants to open a report and see yesterday’s or worse, last week’s data.

In this blog, you’ll learn how to configure schedule refresh in Power BI Service, why it’s important, and what prerequisites you must check before enabling it.

This guide is beginner-friendly and works whether you’re using Power BI Pro or Power BI Premium.

Why Do We Need Schedule Refresh in Power BI?

Once you publish a Power BI report to the Power BI Service and share it with users, the dataset does not refresh automatically unless you configure it.

Imagine this scenario:

  • You build a Power BI report

  • Publish it to production

  • Share it with business users

  • Then move on to another project

If schedule refresh is not enabled:
❌ Users will see outdated data
❌ Manual refresh becomes a dependency
❌ Trust in reports reduces

👉 Schedule Refresh solves this problem by automatically refreshing your dataset at defined intervals, ensuring users always see the latest data.

Prerequisites Before Configuring Schedule Refresh

Before enabling schedule refresh, make sure the following conditions are met:

✅ 1. Dataset Is Published to Power BI Service

Schedule refresh can only be configured after publishing the report from Power BI Desktop.

✅ 2. Gateway Configuration (If Required)

  • Cloud data sources → No gateway required

  • On-premises sources (SQL Server, Oracle, etc.) → Gateway must be configured and running

✅ 3. Data Source Credentials

  • Make sure the data source credentials are configured correctly



⚠️ If the gateway & Data Source credentials is not configured correctly, the refresh will fail.

Step-by-Step: Configure Schedule Refresh in Power BI Service

Follow these steps to enable schedule refresh:

Step 1: Open Your Workspace

  • Go to Power BI Service

  • Navigate to the workspace where your report is published

Step 2: Locate the Dataset (Semantic Model)

  • Find your dataset (now called Semantic Model)

  • Click on the Schedule Refresh icon or Settings

Step 3: Open Refresh Settings

  • Scroll down to the Refresh section

  • Turn Schedule Refresh to ON

Step 4: Choose Refresh Frequency

You can choose:

  • Daily

  • Weekly

If you select Daily, the dataset refreshes every day automatically.

Step 5: Select Time Zone

Choose the correct time zone so refresh happens at the expected business time.

Step 6: Add Refresh Times

You can schedule multiple refreshes in a day:

  • Power BI Pro → Up to 8 refreshes/day

  • Power BI Premium → Up to 48 refreshes/day

Click Add another time to schedule additional refresh slots.

Step 7: Configure Failure Notifications

If the refresh fails, Power BI can notify:

  • Semantic Model Owner

  • Specific email addresses

This ensures issues are detected immediately.

Step 8: Apply Settings

Click Apply.

🎉 Your schedule refresh is now enabled!

How to Verify Schedule Refresh Is Working

After enabling schedule refresh:

  1. Go back to the workspace

  2. Check the dataset (Semantic Model)

  3. You’ll see Next Refresh Time displayed

This confirms the refresh schedule is active.

Common Issues & Tips

🔹 Refresh Fails?

  • Check gateway status

  • Verify data source credentials

  • Ensure tables/views still exist

🔹 Performance Tip

  • Avoid unnecessary columns

  • Optimize queries in Power BI Desktop

🔹 Best Practice

  • Schedule refresh during off-peak hours

Key Takeaways

✔ Schedule refresh keeps reports updated automatically
✔ Gateway is mandatory for on-premises data sources
✔ Pro and Premium have different refresh limits
✔ Email notifications help monitor failures

Frequently Asked Questions (FAQs)

❓ How many times can I refresh Power BI dataset per day?

  • Power BI Pro: 8 times

  • Power BI Premium: 48 times

❓ Do I need a gateway for Azure SQL or SharePoint?

No. Cloud sources do not require a gateway.

❓ What happens if schedule refresh fails?

Power BI sends a failure notification email to configured recipients.

🔚 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/

📞 1-on-1 Consultation
👉 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