BenchMark Quizzes by MDFT Pro

Identify Data Refresh Timing In Power BI Visuals

You create a Power BI dataset at MDFT Academy using DirectQuery and local Excel files. The dataset includes tables for sales, country, and product managers, each with different refresh behaviors.

You need to explain to a user when the data in the visualizations was last refreshed. Which statements about data refresh in visuals is correct?

Choose all correct answers from the options below.

Explanations for each answer:

Visuals referring to calculated tables that use DirectQuery show the most recent values from the data source. is incorrect. Calculated tables are evaluated at the time of the dataset refresh or data load and remain static until the next refresh, even if they are based on DirectQuery sources.
Visuals referring to tables that use DirectQuery show the most recent values from the data source. is correct. Sales uses DirectQuery, so visuals always show the latest data from the source.
Visuals referring to Excel workbooks imported from a local drive show the values from the last scheduled refresh by the Power BI Service. is incorrect. Excel files stored only on a local computer cannot be refreshed automatically in the Power BI Service. Visuals will always show data from the most recent manual import or re-upload, not live or scheduled updates.
Visuals referring to tables that use Import show the values from the last scheduled refresh by the Power BI Service. is correct. If a table is imported and scheduled to refresh, visuals show data from the last refresh, not always the latest from the source.

Learn more about data refresh in Power BI:

Power BI Data Refresh

Exam Preparation Quiz

Identify Data Refresh Timing In Power BI Visuals