The BI engine's behavior is frozen by a set of reference tests (outputs pinned to an identical result on every run). If a number changes, it's because the data changed — not the formula. See Measures, formulas, and KPIs and the Formula catalog.
Formulas / measures#
| Symptom | Likely cause | How to check | Fix | Prevention |
|---|---|---|---|---|
Measure returns empty/— | column/table missing from the model | check the name in the semantic model | fix the measure's reference | name columns in a stable way |
| Syntax error in the formula | invalid function/argument | read the formula editor's message | look up the function in the catalog | use autocomplete and the catalog examples |
| Total doesn't match the sum of the rows | aggregation/filter context | check whether it uses an aggregatable measure (e.g., SOMA, the sum function) | use the right function (see the catalog) | prefer explicit measures over manual sums |
| Division produces an error/infinity | zero/null divisor | test with DIVIDIR/SEERRO (divide / if-error) | use DIVIDIR(a; b) (handles zero) | handle nulls at the source/Silver |
| Period calculation (YoY/MoM) wrong | date table/time context | check the model's date column | use the catalog's time functions | keep a continuous date dimension |
| Number changed "on its own" | source data changed (the engine is frozen) | compare snapshots over time | expected; investigate the source | track freshness/lineage |
Visuals / dashboards#
| Symptom | Likely cause | How to check | Fix | Prevention |
|---|---|---|---|---|
| Visual doesn't render | empty data after filtering | remove filters to isolate it | adjust the filter/query | validate the visual with test data |
| Axis/labels cut off | canvas layout | resize the widget | adjust size/theme | use the canvas editor grid |
| Inconsistent colors/theme | dashboard theme/template | check the applied theme | standardize via the theme | set a default workspace theme |
| Filter doesn't affect a visual | visual outside the filter's scope | check the interactions | adjust the filter's reach | document the cross-filter behavior |
| Table/matrix cuts rows on screen | virtualization (screen ≠ export) | compare with the export | export for the complete total | see Export |
Overview of problems#
- Isolate it: is the problem in the data (origin/pipeline), in the model (reference), in the formula (syntax/context), or in the visual (layout/filter)?
- Reproduce it with a minimal filter.
- Confirm in the semantic model that the column/measure exists with the expected name.
Security#
- Don't paste sensitive data into tickets. Describe the formula/visual and the symptom.
Related#
- Semantic model
- Measures, formulas, and KPIs
- Formula catalog
- Visuals · Editor, canvas, pages, and themes
Last reviewed: 2026-09-08. The BI engine is checked by a set of reference tests on every release.