How to Set Up Scheduled Refreshes in Power BI

How do you set up scheduled refreshes in Power BI? You set up scheduled refreshes in Power BI by publishing your report to the Power BI Service, configuring a refresh schedule in the dataset settings, and ensuring proper gateway and authentication setup, so your dashboards always reflect the latest data without manual updates.

For enterprise executives, scheduled refreshes ensure that stakeholders are always working with real-time or near-real-time insights, improving decision-making and reducing data latency across operations.

Step 1: Publish Your Report to the Power BI Service

Start by publishing your Power BI report from Power BI Desktop to the Power BI Service:

1. Open your report in Power BI Desktop
2. Click Publish (top right)
3. Sign in to your Microsoft 365 account
4. Choose the appropriate workspace

Your dataset and report are now accessible in the Power BI Service at https://app.powerbi.com

Tip: Only reports in the Power BI Service can have scheduled refreshes, local files won’t support this feature.

Step 2: Configure Data Source Credentials

Before scheduling a refresh, ensure Power BI can access your data securely:

1. In the Power BI Service, go to Workspaces > [Your Workspace]
2. Click the More options (⋯) next to your dataset
3. Select Settings
4. Expand the Data source credentials section
5. Choose the appropriate authentication method (e.g., OAuth2, Basic, Windows)
6. Enter and save credentials

Security Tip: Use service accounts or managed identities to avoid expired or personal credentials.

Step 3: Set Up a Gateway (for On-Premises Data)

If your report uses on-premises data sources (e.g., SQL Server, Excel on a shared drive), install and configure a Power BI Gateway:

1. Download and install the On-Premises Data Gateway from Power BI Gateway page 
2. Register the gateway with your Power BI account
3. In the dataset settings, map each data source to the configured gateway

Enterprise Insight: Use a centralized gateway managed by IT to support refreshes across departments securely.

Step 4: Schedule Automatic Refreshes

Now you’re ready to schedule refreshes:

1. Go to Dataset settings in Power BI Service
2. Scroll to Scheduled refresh
3. Toggle Keep data updated to On
4. Set the refresh frequency:
   • Daily or weekly
   • Up to 8 times/day with a Pro license
   • Up to 48 times/day with Premium capacity
5. Set the refresh times (e.g., 8:00 AM, 12:00 PM, 5:00 PM)
6. Choose the time zone
7. Click Apply

Timing Tip: Schedule refreshes based on your business hours, data update frequency, and reporting needs.

Step 5: Monitor and Troubleshoot Refreshes

Power BI logs each refresh attempt and status:

• View refresh history under Settings > Dataset > Refresh History
• Check logs for errors like:
  • Invalid credentials
  • Gateway connection issues
  • Data source changes
• Set up email notifications for failed refreshes

Reliability Tip: Combine scheduled refresh with manual refresh options for urgent data updates.

Step 6: Optimize Data Models for Efficient Refresh

To avoid performance bottlenecks:

• Remove unnecessary columns and rows
• Use incremental refresh (for large datasets)
• Avoid complex queries in Power Query
• Use parameters for dynamic filtering

Enabling Incremental Refresh:

1. Define RangeStart and RangeEnd parameters
2. Apply filters in Power Query
3. In Power BI Service, turn on Incremental refresh policy

Scalability Tip: Incremental refresh significantly reduces load times and processing for large-scale enterprise datasets.

Final Thoughts

Setting up scheduled refreshes in Power BI ensures your reports and dashboards are always up to date, without manual intervention. Whether you’re using cloud, on-premises, or hybrid data sources, scheduled refresh is a vital component of enterprise-grade business intelligence.