Exam Preparation Quiz

Explanations for each answer:

• = DateTimeZone.UtcNow() is incorrect. DateTimeZone.UtcNow() returns the current UTC date and time, but does not create a table or column for use in Power BI reports. It is not the recommended approach for displaying refresh time.
• = DateTime.From(DateTime.LocalNow) is incorrect. DateTime.From(DateTime.LocalNow) converts the local time to a datetime value, but does not generate a table structure required for displaying the refresh time in a report.
• = #table({"Refreshed"}, {{DateTime.FixedLocalNow()}}) is correct. This M code creates a one-row, one-column table with the fixed local date/time at the moment the query was evaluated (i.e., when the dataset was last refreshed). DateTime.FixedLocalNow() captures the refresh timestamp reliably, and the table structure allows the value to be used directly in report visuals.
• = #table({"Refreshed"}, {{DateTime.LocalNow()}}) is incorrect. Although this creates a table with the current local date/time, DateTime.LocalNow() re-evaluates dynamically whenever the query or visuals recalculate, which can lead to inconsistent or misleading timestamps that do not necessarily reflect the true refresh time.