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
| Field | Takes | Needed | What it is for |
|---|---|---|---|
Refreshed Atrefreshed | Measure | Optional | When 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 Throughthrough | Measure | Optional | The last date the data covers, e.g. CALCULATE(MAX(Sales[Order Date]), REMOVEFILTERS()). Tested against the expected lag. |
Sourcesource | Column | Optional | Optional: one row per source or table (a load log, dataflows). Shows a list with a state per source. |
Source Detaildetail | Column | Optional | Optional text under each source name: owner, system, schedule. |
Last Statusstatus | Measure | Optional | Optional: 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 Refreshnext | Measure | Optional | Optional: the next scheduled refresh, when your data knows it. Wins over the Refresh Schedule card. |
Ageing After (Hours)ageingAfter | Measure | Optional | Optional per-source threshold from your data; wins over the format pane. |
Stale After (Hours)staleAfter | Measure | Optional | Optional per-source threshold from your data; wins over the format pane. |
Tooltipstooltips | Measure | Optional · up to 5 | Extra measures shown in the tooltip. |
Themetheme
| Setting | Type and options |
|---|---|
ThemeselectedTheme |
|
Transparent BackgroundtransparentBg | On / off |
Layoutlayout
| Setting | Type and options |
|---|---|
Layoutlayout |
|
Alignmentalign |
|
Chip PositionchipCorner |
|
Source Orderorder |
|
Shapeshape |
|
Fontfont |
|
Text Size (px, 0 = Fit)textSize | Number |
Headline Size (%)headlineSize | Number |
Secondary Text Size (%)secondarySize | Number |
Showcontent
| Setting | Type and options |
|---|---|
State Iconicon | On / off |
State WordstateWord | On / off |
Relative Age (2 hours ago)relative | On / off |
Refresh Time (today 06:04)absolute | On / off |
Last Status (Succeeded / Failed)status | On / off |
Time Zone Name (CEST)zoneName | On / off |
Data Throughthrough | On / off |
Next Refreshnext | On / off |
Reason When Not Freshreason | On / off |
Summary Line (Source List)summary | On / off |
Column Headers (Source List)headers | On / off |
Age Bar (Status Card)ageBar | On / off |
UTC Time (Status Card)utcRow | On / off |
Business-Time Age (Status Card)businessAge | On / off |
As-Of StampasOf |
|
Time Zonestime
| Setting | Type and options |
|---|---|
Refresh Time Is Stored AsstoredAs |
|
Stored Time ZonestoredZone | Text |
Show Times IndisplayZone |
|
Business Time ZonebusinessZone | Text |
Clockclock |
|
Relative WordingrelStyle |
|
Keep Ageing While Openlive | On / off |
Refresh Agestaleness
| Setting | Type and options |
|---|---|
Ageing After (Hours, 0 = Off)ageingHours | Number |
Stale After (Hours, 0 = Off)staleHours | Number |
Count Age IncountIn |
|
Data Coveragecoverage
| Setting | Type and options |
|---|---|
Expected Lag (Days)expectedLag | Number |
Ageing When Behind By (Days, 0 = Off)ageingDays | Number |
Stale When Behind By (Days, 0 = Off)staleDays | Number |
Count Missing Days IncountIn |
|
Date FormatdateStyle |
|
Labellabel |
|
Refresh Scheduleschedule
| Setting | Type and options |
|---|---|
Scheduled Times (06:00, 12:30)times | Text |
Runs Ondays |
|
Late After (Minutes)graceMinutes | Number |
Show Next Refresh As Approximate (~)approx | On / off |
Last StatuslastStatus
| Setting | Type and options |
|---|---|
Numeric Status Codescodes |
|
A Failed Last Run Makes the SourceonFailure |
|
Business Calendarcalendar
| Setting | Type and options |
|---|---|
Weekendweekend |
|
Working Hours (08:00-18:00, Empty = Whole Day)hours | Text |
Holidays (YYYY-MM-DD, Comma Separated)holidays | Text |
Textwording
| Setting | Type and options |
|---|---|
Refreshed Labelrefreshed | Text |
Data Through Labelthrough | Text |
Next Refresh Labelnext | Text |
Last Status Labelstatus | Text |
Source Column Labelsource | Text |
State Column LabelstateCol | Text |
Your Time LabelyourTime | Text |
Fresh Wordfresh | Text |
Ageing Wordageing | Text |
Stale Wordstale | Text |
Unknown Wordunknown | Text |
Colorscolors
| Setting | Type and options |
|---|---|
Backgroundbackground | Colour |
Badge / Card Fillsurface | Colour |
Borderborder | Colour |
Texttext | Colour |
Secondary Textmuted | Colour |
Accent and Rulesaccent | Colour |
Freshfresh | Colour |
Ageingageing | Colour |
Stalestale | Colour |
Unknownunknown | Colour |
Sourcessources
| Setting | Type and options |
|---|---|
Display Namelabel | Text |
Ageing After (Hours, 0 = Default)ageingHours | Number |
Stale After (Hours, 0 = Default)staleHours | Number |
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" } } }
}
}]
}
}