Skip to main content
subagent CX Codex

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

Install into GitHub Copilot · Manually: put the files in place All methods and platforms ↓
.github/agents/semantic-model-auditor.agent.md
Open on GitHub

What 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 CALCULATE statements 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.md

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.

Similar subagents

All subagents for Data and databases →
Power BI Authoring MCP Server (Local) microsoft Power BI Authoring MCP Server (Local) is an MCP server for editing Power BI semantic models. It manages tables, relationships, DAX measures, and TMDL files from chat. CX Codex +1 ★ 1,297repo stars Horizun PBI MCP HorizunGroup Horizun PBI MCP connects coding agents to Power BI Desktop instances and PBIP repositories. Runs DAX queries, edits semantic models, and validates report structures. CX Codex +1 ★ 34repo stars power-bi-model-design-review official github power-bi-model-design-review reviews Power BI model architecture, relationships, and storage modes. Use it before a model release or when investigating slow queries. CX Codex +1 9,000installs power-bi-dax-optimization official github power-bi-dax-optimization reviews DAX formulas, proposes a revised version, and explains the changes. Use it when Power BI measures are hard to read or slow under filters. CX Codex +1 9,100installs power-bi-salespulse-360-dashboard reason-machines power-bi-salespulse-360-dashboard is a Claude Code skill for configuring the SalesPulse 360 Power BI dashboard. It activates for retail sales and profit analysis, regional reporting, forecasting, and alert setup. CX Codex +1 661installs power-bi-retail-analytics-salespulse360 reason-machines power-bi-retail-analytics-salespulse360 is a skill that deploys and tunes the SalesPulse 360 Power BI retail dashboard for revenue tracking, regional margins, and predictive forecasting. CX Codex +1 659installs

From the same set59

The whole set →
pbip-validator pbip-validator — a subagent that diagnoses structural errors, JSON schema violations, and TMDL syntax issues in Power BI projects. Runs when you need to verify project integrity before opening in Desktop or after renaming tables. CX Codex +1 ★ 1,104repo stars organize-semantic-model organize-semantic-model is a Claude Code skill that cleans and structures Power BI and Analysis Services semantic models via Tabular Editor 3 or the te CLI before reports are handed off. CX Codex +1 ★ 1,104repo stars refresh-semantic-model The refresh-semantic-model Claude Code skill runs and monitors Power BI refreshes, then compares data before and after for a whole model or selected tables and partitions. CX Codex +1 ★ 1,104repo stars paginated-report A skill for authoring, validating, and publishing Power BI paginated reports in RDL format — invoices, statements, regulatory filings. CX Codex +1 ★ 1,104repo stars create-pbi-report create-pbi-report is a Claude Code skill that builds Power BI reports from semantic models, from page planning to validation and publishing. CX Codex +1 ★ 1,104repo stars c-sharp-scripting c-sharp-scripting is a Claude Code skill that runs C# scripts through Tabular Editor 2/3 to automate bulk changes to Power BI measures, columns, calculation groups, and model security. CX Codex +1 ★ 1,104repo stars pbip Guides Claude Code on structuring Power BI Project (PBIP) files, managing thick vs thin reports, and configuring Git tracking. CX Codex +1 ★ 1,104repo stars querying-fabric querying-fabric is a Claude Code skill that builds and tests DAX queries for Fabric and Power BI semantic models. It prepares data for dashboard KPIs, charts, and tables. CX Codex +1 ★ 1,104repo stars

Project sponsors

Companies that keep this analytics open