From semantic-models
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 this skill is triggered — by the user, by Claude, or both
Slash command
/semantic-models:daxThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Skills and references for writing, debugging, and optimizing DAX in semantic models.
Skills and references for writing, debugging, and optimizing DAX in semantic models.
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:
connect-pbid skill — specifically performance-profiling.md for FE/SE timing and evaluateandlog-debugging.md for intermediate result inspection.powerbi-modeling-mcp VS Code extension for trace and query operations. Install: code --install-extension analysis-services.powerbi-modeling-mcpsemantic-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 changesGuides completion of development work by verifying tests, detecting environment, and presenting structured options for merge, PR, or cleanup.
Enforces test-driven development: write failing test first, then minimal code to pass. Use when implementing features or bugfixes.
Guides creation and editing of skills using test-driven development with pressure scenarios and subagents to verify agent compliance.
npx claudepluginhub federicopfund/power-bi-agentic-development --plugin semantic-models