Scheduled data refresh in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is Scheduled Data Refresh in Power BI?

Scheduled Data Refresh automatically updates your Power BI dataset at set times so your reports show the latest data without manual updates.

beginner

Why do we need Scheduled Data Refresh?

Because data changes over time, scheduled refresh keeps reports current and accurate without needing you to refresh manually.

intermediate

What are the two main types of data sources for Scheduled Refresh in Power BI?

1. Cloud data sources (like Azure SQL, SharePoint Online)<br>2. On-premises data sources (like local SQL Server) which need a gateway.

intermediate

What is a Data Gateway in Power BI Scheduled Refresh?

A Data Gateway is a bridge that securely connects Power BI service to your on-premises data sources so scheduled refresh can access local data.

intermediate

How often can you schedule data refresh in Power BI Pro vs Premium?

Power BI Pro allows up to 8 refreshes per day, while Power BI Premium supports up to 48 refreshes per day for more frequent updates.

What does Scheduled Data Refresh do in Power BI?

A Deletes old data from reports

B Automatically updates datasets at set times

C Sends email alerts when data changes

D Creates new reports automatically

Scheduled Data Refresh updates your dataset automatically so reports show the latest data.

Which component is needed to refresh on-premises data sources?

A Data Gateway

B Power BI Desktop

C Power BI Mobile

D Azure Data Factory

A Data Gateway securely connects Power BI service to on-premises data for refresh.

How many refreshes per day does Power BI Pro allow?

A 8

B 2

C 24

D 48

Power BI Pro allows up to 8 scheduled refreshes per day.

Which data source type does NOT require a gateway for refresh?

A On-premises SQL Server

B Local Excel file

C Azure SQL Database

D Local SharePoint Server

Cloud sources like Azure SQL Database do not require a gateway.

What happens if scheduled refresh fails?

A Power BI deletes the dataset

B The data refreshes manually

C The report refreshes anyway

D You get a failure notification

Power BI sends a notification if the scheduled refresh fails.

Explain how Scheduled Data Refresh works in Power BI and why it is important.

Think about how your reports stay up-to-date without you clicking refresh.

Describe the role of a Data Gateway in Scheduled Data Refresh.

Imagine a secure tunnel between your local data and Power BI service.