Siksha Sarovar

Siksha Sarovar (sikshasarovar.com) is a free educational web application that helps students in India learn programming and prepare for academic and competitive exams. The platform offers structured coding courses (C, C++, Python, Java, HTML, CSS, PHP, Power BI, AI, Machine Learning, Data Science), complete university curriculum notes for BCA/MCA students with previous year question papers, Class 10 and Class 12 CBSE/HBSE school notes, and dedicated preparation material for SSC, UPSC, Banking, Railway and other government exams. Browsing the site is completely free and requires no account. Users may optionally sign in with Google solely to save their learning progress, quiz scores and personal preferences across devices.

Privacy Policy | Terms of Service | Contact Siksha Sarovar | About Siksha Sarovar

v4.0.9 · PWA
Siksha Sarovar logo
Siksha Sarovar
Your Learning Universe

Siksha Sarovar is a free e-learning platform for coding courses, BCA university notes and competitive exam preparation. Optional Google sign-in saves your learning progress across devices.

Initializing knowledge base…
Compiling modules 0%

1.9 Setting Up Scheduled Data Refresh

Lesson 9 of 62 in the free Power BI notes on Siksha Sarovar, written by Rohit Jangra.

Scheduled Data Refresh in Power BI

When using Import mode, data is a snapshot taken at the time of import. To keep reports up-to-date, you can configure scheduled refresh in the Power BI Service.

What is Data Refresh?

Data refresh is the process of re-importing data from the original source into the Power BI dataset. This ensures that your reports and dashboards reflect the latest data.

Types of Refresh

TypeDescription
Manual RefreshClick "Refresh Now" in Power BI Service
Scheduled RefreshAutomatically refresh at set times (up to 8x/day for Pro, 48x/day for Premium)
On-demand RefreshTriggered via API or Power Automate

Setting Up Scheduled Refresh

Pre-requisites: • Report must be published to Power BI Service • Data source credentials must be configured • If data source is on-premises, an On-premises Data Gateway must be installed

Steps:

  1. Go to app.powerbi.com
  2. Navigate to your Workspace
  3. Find your dataset and click the three dots (⋯)Settings
  4. Expand Scheduled Refresh section
  5. Toggle Keep your data up to date to On
  6. Set the Refresh frequency (Daily or Weekly)
  7. Add Time slots for when refreshes should occur
  8. Optionally, set a time zone
  9. Click Apply

On-Premises Data Gateway

If your data source is behind a firewall (e.g., local SQL Server, on-premises files), you need a gateway.

What is a Gateway? • A bridge between Power BI Service (cloud) and on-premises data sources • Installed on a local machine that has access to the data source • Securely transfers data without exposing the source to the internet

Gateway Types:

TypeUse Case
Standard ModeShared gateway for multiple users and datasets
Personal ModeSingle user, single dataset

Troubleshooting Refresh Failures

Common Issues:Expired credentials — Update data source credentials in dataset settings • Gateway offline — Ensure gateway machine is running and connected • Data source unavailable — Verify the source server/file is accessible • Timeout — Optimize queries or reduce data volume • Permission changes — Re-enter credentials if permissions were revoked