← Files Power BI Report CopilotARCHIVED FILE
references/testing-reconciliation.md
780 Bytes · Nov 20, 2026 · 06:46 UTC
# 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