Powerbi Powerquery Test Harness

Use when Power Query extraction or transformation needs tests for query folding, schema drift, nulls, duplicates, pagination, type conversion, incremental refresh, privacy levels, or source reconciliation.

rweisssieker-xp Updated

File contents

Power BI Power Query Test Harness

Use this skill before accepting extraction logic.

Test Areas

  • Query folding and native query pushdown.
  • Schema drift: missing, renamed, added, type-changed columns.
  • Nulls, duplicates, orphan keys, invalid dates.
  • API pagination, throttling, retry, and delta behavior.
  • Incremental refresh boundary correctness.
  • Privacy levels, gateway identity, and credential scope.
  • Row counts and source totals.

Output Requirements

  • Include test input, expected output, failure mode, owner, and remediation.
  • Mark non-folding transformations as risks when data volume is high.

rweisssieker-xp/powerbi-codex-plugin/tree/main/plugins/powerbi-business-intelligence/skills/powerbi-powerquery-test-harness commit d275d117e8

Frequently asked questions

npx skillmds@latest add rweisssieker-xp/powerbi-powerquery-test-harness