← Files Power BI Report CopilotARCHIVED FILE

references/testing-reconciliation.md

780 Bytes · Nov 20, 2026 · 06:46 UTC

↓ Download file

See the change to this file →

# Source-to-export reconciliation
Define expected business metric, grain, source-of-truth definition, filters, time window, currency/units, exact/allowed tolerance and row-level keys. Compare source → Power Query → semantic model → DAX/tablix → renderer/export.
Minimum matrix: unfiltered total, each key parameter, nulls, duplicates, empty result, date boundaries, long text, multi-page export, unauthorized recipient. Distinguish actual numeric evidence from hypothetical fixtures, and record provenance to a query/run ID or test file.
A PASS requires observed outcome consistent with expected result. FAIL requires cause and owner. NOT RUN remains NOT RUN; it must not silently become PASS. Use `templates/report-reconciliation.md` and `templates/release-evidence.md`.

SHA-256: 151209c40f3f88c542a10c78d891ca0d3475c986d125c192a09c17e09da9d9b4