Data Freshness fields and settings

    Every field well and every setting in the format pane of version 1.0.0.0, read from the package you download. The internal names in grey are what a PBIR file or a report-authoring agent uses. Which features need a licence is on the Data Freshness page; every setting works in edit mode with or without one.

    9 fields · 12 cards · 75 settings Markdown for AI assistantscatalog.json

    Fields

    FieldTakesNeededWhat it is for
    Refreshed AtrefreshedMeasureOptionalWhen the data was last refreshed. Recipe: a one-row Power Query table with DateTimeZone.RemoveZone(DateTimeZone.UtcNow()), then MAX of it. Read as UTC by default (Time Zones card).
    Data ThroughthroughMeasureOptionalThe last date the data covers, e.g. CALCULATE(MAX(Sales[Order Date]), REMOVEFILTERS()). Tested against the expected lag.
    SourcesourceColumnOptionalOptional: one row per source or table (a load log, dataflows). Shows a list with a state per source.
    Source DetaildetailColumnOptionalOptional text under each source name: owner, system, schedule.
    Last StatusstatusMeasureOptionalOptional: the outcome of the last refresh run, as text (Succeeded, Failed, Cancelled) or a numeric code (Last Status card). Shown next to the refresh time; a failed run marks the source stale by default.
    Next RefreshnextMeasureOptionalOptional: the next scheduled refresh, when your data knows it. Wins over the Refresh Schedule card.
    Ageing After (Hours)ageingAfterMeasureOptionalOptional per-source threshold from your data; wins over the format pane.
    Stale After (Hours)staleAfterMeasureOptionalOptional per-source threshold from your data; wins over the format pane.
    TooltipstooltipsMeasureOptional · up to 5Extra measures shown in the tooltip.

    Themetheme

    SettingType and options
    ThemeselectedTheme
    • SmartVisuals smartvisuals
    • Dark dark
    • Clean clean
    • Slate slate
    Transparent BackgroundtransparentBgOn / off

    Layoutlayout

    SettingType and options
    Layoutlayout
    • Auto (fit the space) auto
    • Badge badge
    • Header strip strip
    • Corner chip chip
    • Status card card
    • Source list list
    Alignmentalign
    • Auto auto
    • Left left
    • Center center
    • Right right
    Chip PositionchipCorner
    • Top right topRight
    • Top left topLeft
    • Bottom right bottomRight
    • Bottom left bottomLeft
    • Center center
    Source Orderorder
    • Worst first worst
    • As in the data data
    Shapeshape
    • From the theme theme
    • Pill pill
    • Rounded rounded
    • Square square
    Fontfont
    • From the theme (Inter / Segoe UI) theme
    • Segoe UI segoe
    • Arial arial
    • Georgia georgia
    • Monospace mono
    Text Size (px, 0 = Fit)textSizeNumber
    Headline Size (%)headlineSizeNumber
    Secondary Text Size (%)secondarySizeNumber

    Showcontent

    SettingType and options
    State IconiconOn / off
    State WordstateWordOn / off
    Relative Age (2 hours ago)relativeOn / off
    Refresh Time (today 06:04)absoluteOn / off
    Last Status (Succeeded / Failed)statusOn / off
    Time Zone Name (CEST)zoneNameOn / off
    Data ThroughthroughOn / off
    Next RefreshnextOn / off
    Reason When Not FreshreasonOn / off
    Summary Line (Source List)summaryOn / off
    Column Headers (Source List)headersOn / off
    Age Bar (Status Card)ageBarOn / off
    UTC Time (Status Card)utcRowOn / off
    Business-Time Age (Status Card)businessAgeOn / off
    As-Of StampasOf
    • In exports and snapshots auto
    • Always always
    • Never never

    Time Zonestime

    SettingType and options
    Refresh Time Is Stored AsstoredAs
    • UTC (recommended recipe) utc
    • The viewer's time zone viewer
    • A time zone or offset (type below) zone
    Stored Time ZonestoredZoneText
    Show Times IndisplayZone
    • The viewer's own time zone viewer
    • UTC utc
    • The business time zone business
    Business Time ZonebusinessZoneText
    Clockclock
    • From the report language auto
    • 24-hour (18:30) 24
    • 12-hour (6:30 PM) 12
    Relative WordingrelStyle
    • Long (2 hours ago) long
    • Short (2 hr. ago) short
    • Narrow (2h ago) narrow
    Keep Ageing While OpenliveOn / off

    Refresh Agestaleness

    SettingType and options
    Ageing After (Hours, 0 = Off)ageingHoursNumber
    Stale After (Hours, 0 = Off)staleHoursNumber
    Count Age IncountIn
    • Business time (working days and hours) business
    • Calendar time calendar

    Data Coveragecoverage

    SettingType and options
    Expected Lag (Days)expectedLagNumber
    Ageing When Behind By (Days, 0 = Off)ageingDaysNumber
    Stale When Behind By (Days, 0 = Off)staleDaysNumber
    Count Missing Days IncountIn
    • Working days business
    • Calendar days calendar
    Date FormatdateStyle
    • Auto (yesterday, Fri 26 Sep) auto
    • Short (26/09/2026) short
    • Medium (26 Sep 2026) medium
    • Long (26 September 2026) long
    • ISO (2026-09-26) iso
    Labellabel
    • Data through words
    • The measure's name (Sales through) field

    Refresh Scheduleschedule

    SettingType and options
    Scheduled Times (06:00, 12:30)timesText
    Runs Ondays
    • Working days workdays
    • Every day every
    Late After (Minutes)graceMinutesNumber
    Show Next Refresh As Approximate (~)approxOn / off

    Last StatuslastStatus

    SettingType and options
    Numeric Status Codescodes
    • 0 = succeeded, other = failed (exit codes) exit
    • SQL Agent (1 succeeded, 0 failed, 4 running) sqlAgent
    • HTTP (2xx succeeded, 4xx/5xx failed) http
    A Failed Last Run Makes the SourceonFailure
    • Stale stale
    • Ageing ageing
    • No change (show the status only) none

    Business Calendarcalendar

    SettingType and options
    Weekendweekend
    • Saturday and Sunday satSun
    • Friday and Saturday friSat
    • Sunday only sun
    • No weekend none
    Working Hours (08:00-18:00, Empty = Whole Day)hoursText
    Holidays (YYYY-MM-DD, Comma Separated)holidaysText

    Textwording

    SettingType and options
    Refreshed LabelrefreshedText
    Data Through LabelthroughText
    Next Refresh LabelnextText
    Last Status LabelstatusText
    Source Column LabelsourceText
    State Column LabelstateColText
    Your Time LabelyourTimeText
    Fresh WordfreshText
    Ageing WordageingText
    Stale WordstaleText
    Unknown WordunknownText

    Colorscolors

    SettingType and options
    BackgroundbackgroundColour
    Badge / Card FillsurfaceColour
    BorderborderColour
    TexttextColour
    Secondary TextmutedColour
    Accent and RulesaccentColour
    FreshfreshColour
    AgeingageingColour
    StalestaleColour
    UnknownunknownColour

    Sourcessources

    SettingType and options
    Display NamelabelText
    Ageing After (Hours, 0 = Default)ageingHoursNumber
    Stale After (Hours, 0 = Default)staleHoursNumber

    Setting a value in PBIR

    In a visual.json, a setting goes under visual.objects, by card and internal name. Toggles take true or false, choices and text a value in single quotes ('auto'), numbers a D suffix (12D).

    "visual": {
      "visualType": "dataFreshness4BAAAB2339CF41DABFC1E0BFB560FA50",
      "objects": {
        "theme": [{
          "properties": {
            "transparentBg": { "expr": { "Literal": { "Value": "true" } } }
          }
        }]
      }
    }