powerbi-dax-unit-test-runner

name	powerbi-dax-unit-test-runner
description	Use when DAX measures require executable or semi-executable unit tests, query-based assertions, XMLA or Tabular Editor validation, edge cases, totals, RLS contexts, and reconciliation evidence.

Power BI DAX Unit Test Runner

Design DAX tests that can be executed through DAX queries, XMLA, Tabular Editor workflows, or documented manual evidence.

Output Contract

• Measure under test, KPI contract, expected result, filter context, date context, and RLS context.
• Test cases for totals, blanks, zero denominators, many-to-many risk, time intelligence, currency, and segment filters.
• Execution route: DAX query, Tabular Editor script, XMLA endpoint, Performance Analyzer export, or manual reconciliation.
• Pass/fail criteria, evidence capture, owner, and remediation.

Checks

• Do not treat visual inspection as sufficient for certified measures.

Runtime Executor

For dataset-backed DAX validation, create a credential-safe DAX query request:

python scripts\powerbi_expert_factory.py dax-query-request --workspace <workspace-id> --dataset <dataset-id> --query "EVALUATE ROW(\"Cases\", [Case Count])" --out outputs\runtime-executors\dax-query-request.json