Dax
Testing & QualitydaxDax is an Agent Skill for testing & quality published in the data-goblin/power-bi-agentic-development repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.
DAX performance optimization for semantic models. Automatically invoke when the user asks to "optimize DAX", "fix slow DAX", "DAX performance", "tune a measure", "debug a measure", "DAX anti-patterns", or mentions slow queries, server timings, or DAX authoring.
How to use this skill
Bring this guide into your coding agent with a prompt tailored to the tool you use.
- Open your project in Codex.
- Copy and paste the prompt below.
- Review files and risks before approving any action.
Inspect the Agent Skill at https://github.com/data-goblin/power-bi-agentic-development/blob/HEAD/plugins/semantic-models/skills/dax/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/dax, but wait for my approval before writing files or running scripts.
Copying this prompt does not install or run the skill. Review third-party files before use.
DAX
Skills and references for writing, debugging, and optimizing DAX in semantic models.
Optimization
For systematic DAX query performance optimization, read the workflow reference first:
references/dax-performance-optimization.md — Tiered framework (4 tiers), phased workflow, decision guide, and error handling.
Detailed reference files (progressive disclosure — consult as directed by the workflow):
references/engine-internals.md— FE/SE architecture, xmSQL, compression/segments, SE fusion, trace diagnosticsreferences/dax-patterns.md— Tier 1 DAX patterns (DAX001–DAX021) + Tier 2 query structure (QRY001–QRY004)references/model-optimization.md— Tier 3 model patterns (MDL001–MDL009) + Tier 4 Direct Lake (DL001–DL002)
Trace capture and performance profiling:
- Local models (Power BI Desktop): Use the Tabular Editor CLI
te query(see thete-cliskill) first; as an alternative, theconnect-pbidskill covers FE/SE timing (performance-profiling.md) and intermediate result inspection (evaluateandlog-debugging.md). - Remote models (Fabric Service / XMLA): Run DAX with the Tabular Editor CLI
te query(-s <workspace> -d <model>) against the workspace XMLA endpoint; see thete-cliskill (tabular-editor plugin). - Power BI Modeling MCP: also available for trace and query if you prefer an MCP tool; reach for it after the options above.
Related Skills
semantic-model— Model design, build, and auditing including DAX anti-patterns and best practicesconnect-pbid(pbi-desktop plugin) — Trace capture, performance profiling, EVALUATEANDLOG debugginglineage-analysis— Impact analysis before model changes