semantic-model-auditor — Claude Code subagent: install and review
semantic-model-auditor audits Power BI and Fabric semantic models for memory bottlenecks, schema issues, and DAX anti-patterns by inspecting exported TMDL files.
GPL-3.0 ★ 1,104 updated 2026-10-28
.github/agents/semantic-model-auditor.agent.mdWhat semantic-model-auditor does
This subagent automates reviews of Fabric and Power BI semantic models. It triggers the audit by exporting the workspace model to /tmp/audit via the Fabric CLI command fab export. This generates a directory of TMDL files covering tables, relationships, and model settings.
The agent then inspects the TMDL files against specific severity checks. It flags bidirectional cross-filtering, circular measure references, missing data types, and auto-generated tables like LocalDateTable_*. To tackle memory consumption, it spots unsplit datetime fields, unneeded calculated columns, and high-cardinality keys that inflate VertiPaq dictionaries. In DAX formulas, it highlights nested CALCULATE statements and costly DISTINCTCOUNT operations.
Fabric CLI (fab) must be installed and authenticated in your shell environment. Without access to the target workspace, the export step fails immediately and halts the audit.
What it helps with
- detect bidirectional relationships and circular dependencies across measures
- identify unsplit datetime columns and high-cardinality keys consuming memory
- catch auto-generated date hierarchy tables bloating model size
- locate redundant nested
CALCULATEstatements in DAX code
Example prompts for the agent
- Audit the Sales model in the Production workspace for performance bottlenecks
- Run a best practice check on my semantic model before release
- Inspect the exported model for DAX anti-patterns and high-cardinality columns
How to install semantic-model-auditor
Manually: put the files in place
.github/agents/semantic-model-auditor.agent.md1Plugin marketplace
/plugin marketplace add data-goblin/power-bi-agentic-development/plugin install semantic-models@power-bi-agentic-development2Manually: put the files in place
.claude/agents/semantic-model-auditor.mdFor all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention. Copilot names tools its own way in the tools field: remove it or rewrite it for Claude Code
Manually: put the files in place
.codex/agents/semantic-model-auditor.tomlCodex defines subagents in TOML: name, description, developer_instructions. Move the Markdown text into developer_instructions by hand. For all projects use ~/.codex/agents/
Manually: put the files in place
.cursor/agents/semantic-model-auditor.mdCursor also reads .claude/agents/
Step by step, with commands for each platform: Claude Code subagents: how to create one, call it and keep context clean
Questions about semantic-model-auditor
How to install semantic-model-auditor in Claude Code?
Add the marketplace source with /plugin marketplace add data-goblin/power-bi-agentic-development, then install it using /plugin install semantic-models@power-bi-agentic-development.
What does semantic-model-auditor do?
It exports a Power BI or Fabric semantic model to TMDL files and reviews them for schema flaws, DAX anti-patterns, and VertiPaq memory bloat.
What external tools are required for this audit?
You need the Fabric CLI (fab) configured and logged in, because the subagent depends on fab export to retrieve model files.