Microsoft Certified: Power BI Data Analyst AssociateDeploy and maintain assetsEasy
A data analyst has developed a Power BI report that uses an imported dataset. The dataset's data source is a SQL Server database. To ensure that the report data is always up-to-date for end-users, which type of refresh should be configured for the dataset in the Power BI Service?
- AScheduled Refresh
- BDirectQuery
- CPush Dataset
- DLive Connection
Show answer & explanationAnswer & explanation
Correct answer: A. Scheduled Refresh
For imported datasets, data needs to be periodically fetched from the source. Scheduled Refresh automates this process in the Power BI Service, ensuring the report displays the latest information without manual intervention.
Why the other options are wrong
- B. DirectQuery maintains a live connection to the data source, but the question specifies an 'imported dataset', which requires refresh.
- C. Push Datasets are updated programmatically via API, not typically configured for automatic refresh for a standard imported SQL Server dataset.
- D. Live Connection is used for SQL Server Analysis Services or Azure Analysis Services, not for imported datasets from SQL Server.
Scheduled Data Refresh
A Power BI Service feature that automatically updates imported datasets from their original data sources at predefined intervals.
- Applies to imported datasets.
- Configured in Power BI Service.
- Requires a gateway for on-premises sources.
Memory trick: Imported data needs a schedule to stay fresh.