SmartVisuals Data Freshness

Every reader knows how fresh the numbers are, in their own time zone. SmartVisuals Last Refresh & Data Freshness shows "Refreshed 3 hours ago (today 06:04) - Succeeded - Data through yesterday" on any report page, keeps ageing while the report is open, and says why when the data is not fresh.

Your time zone, not the server's. Store the refresh time in UTC and the browser converts it for each reader, daylight saving included, with the zone named in the reader's language (CEST, EDT or GMT+2). DAX cannot do this: NOW() and UTCNOW() run in the service's zone.

Three inputs, all tested. Refreshed At says when the model refreshed, Data Through says what the data covers, and Last Status says whether the last run worked. A model that refreshed on time but loaded nothing since Tuesday is stale, a blank Data Through is flagged, and a failed run marks the source stale, with the reason printed.

• States you can read without colour: Fresh, Ageing, Stale and Unknown, each with its own icon shape and word.
• Business time by default: a quiet weekend is not stale. Working days, optional working hours and holidays count; calendar time is one click away.
• The refresh schedule: type your schedule and the visual knows when a run is late ("the 06:00 refresh is late") and when the next one is due, skipping holidays.
• Last refresh status: bind Succeeded / Failed text or a numeric code (exit codes, SQL Agent, HTTP) and it shows next to the time.
• Many sources: bind a load log and every source gets its own state, reason, status and thresholds, from the format pane or from your data.
• Five layouts: badge, header strip, corner chip, status card and source list, or Auto. One-line layouts shed parts instead of cutting text; the list wraps long reasons and the tooltip has them in full.
• Exact times on hover: your time, UTC, the storage zone, the exact age and the business-time age.
• Honest when frozen: the absolute time is always printed next to the relative one, and an As-of stamp is added when the visual renders without interaction.
• Guards against mistakes: a refresh time or data date in the future, or a value the visual cannot read, is flagged and never shown as fresh; a zone abbreviation without daylight saving (EST) is refused with a hint for the author.
• Four themes, full format pane in English, Czech and German, cross-filtering, keyboard, screen reader and high contrast.

Getting started: add a one-row Power Query table with DateTimeZone.RemoveZone(DateTimeZone.UtcNow()) and a measure MAX of it, plus a Data Through measure such as MAX of your order date. The landing page and the sample report show both recipes.

Free, with nothing leaving your report: no licence, no watermark, no network calls, no telemetry. Part of the SmartVisuals family: smartvisuals.io