Skip to main content
skill CX Codex

dax — Claude Code skill: DAX query optimization

A skill for diagnosing and speeding up DAX queries in Power BI semantic models, working through slow measures tier by tier.

GPL-3.0 ★ 1,104 updated 2026-10-28

Install into Claude Code · Plugin marketplace All methods and platforms ↓
/plugin marketplace add data-goblin/power-bi-agentic-development
/plugin install semantic-models@power-bi-agentic-development
Open on GitHub

What dax does

The skill fixes one convention for naming DAX objects: columns are written as 'Table'[Column] with the table name quoted, measures as [Measure] with no table prefix, since a measure belongs to the model rather than any single table. That convention carries through measures, calculated columns, RLS filters, format string expressions and DAX queries alike.

Its core is a workflow reference, dax-performance-optimization.md, built around a four-tier tuning framework with its own error-handling guide. Supporting files load on demand: engine-internals.md covers FE/SE architecture, xmSQL and segment compression, dax-patterns.md lists patterns DAX001–DAX021 plus query-shape patterns QRY001–QRY004, and model-optimization.md covers model patterns MDL001–MDL009 and Direct Lake patterns DL001–DL002.

For trace capture on local Power BI Desktop models it leans on the Tabular Editor CLI's te query or the companion connect-pbid skill; against remote Fabric Service models it runs the same te query over the workspace's XMLA endpoint. A Power BI Modeling MCP server is listed as a fallback for tracing and querying.

What it helps with

  • track down why a measure evaluates slowly
  • standardize how measures and columns are referenced across a model
  • read xmSQL and segment compression behavior in the engine
  • match a slow pattern to a model-level or Direct Lake fix
  • capture an FE/SE trace for a query

Example prompts for the agent

  • Optimize the Total Sales measure, it's running slow
  • Walk through the FE/SE trace for this query and flag anti-patterns
  • Check this model against the DAX001–DAX021 patterns

How to install dax

1Plugin marketplace

/plugin marketplace add data-goblin/power-bi-agentic-development
/plugin install semantic-models@power-bi-agentic-development

This installs the whole semantic-models plugin with all its skills

2Skills CLI (Vercel)

npx skills add data-goblin/power-bi-agentic-development --skill dax -a claude-code

3Manually: put the files in place

~/.claude/skills/dax/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/dax/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about dax

How to install dax in Claude Code?

Run /plugin marketplace add data-goblin/power-bi-agentic-development, then /plugin install semantic-models@power-bi-agentic-development.

What does the dax skill do?

It helps trace the cause of slow DAX queries and measures in Power BI semantic models and enforces a single convention for referencing model objects. It relies on a four-tier optimization framework with named patterns for diagnosis.

How does dax differ from the semantic-model skill?

dax focuses on DAX code performance and patterns, while semantic-model handles overall model design, build and auditing, including model-level DAX anti-patterns.

Similar skills

All skills for Data and databases →

From the same set59

The whole set →
svg-reviewer svg-reviewer is a Claude Code subagent that checks SVG DAX measures for markup and DAX issues and comments on their design before they are shared with a user. CX Codex +1 ★ 1,104repo stars deneb-reviewer deneb-reviewer validates Vega and Vega-Lite specs for Power BI before presenting them to the user. Catches syntax errors, Deneb convention violations, and offers design feedback. CX Codex +1 ★ 1,104repo stars suggest-rule suggest-rule generates Best Practice Analyzer rules for Tabular Editor from plain text requirements or model files. CX Codex +1 ★ 1,104repo stars migrating-fabric-trial-capacities migrating-fabric-trial-capacities is a Claude Code command that moves Microsoft Fabric workspaces from trial to production capacity through fab CLI, logging each step. CX Codex +1 ★ 1,104repo stars bpa-expression-helper bpa-expression-helper — a subagent for debugging, fixing, and explaining Best Practice Analyzer rule expressions with Dynamic LINQ and TOM properties in Power BI. CX Codex +1 ★ 1,104repo stars query-listener query-listener — a Claude Code subagent that hooks into the local Analysis Services instance and grabs the DAX a Power BI Desktop visual sends. Fire it off when you need to see the query behind a click. CX Codex +1 ★ 1,104repo stars lineage-analysis lineage-analysis finds every Power BI report tied to a semantic model across Fabric workspaces, without needing admin rights. CX Codex +1 ★ 1,104repo stars using-duckdb Query Delta tables and raw files in Fabric OneLake using DuckDB either on your machine or inside a Fabric notebook. CX Codex +1 ★ 1,104repo stars

More in the catalog

Project sponsors

Companies that keep this analytics open