# semantic-model

semantic-model guides tabular data modeling for Power BI and Analysis Services from the terminal across design, refresh, and review tasks.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, Windsurf (Devin Desktop), Claude.ai · ★ 1104 repo stars
- Author: Kurt Buhler
- License: GPL-3.0 · policy=link-only · description only; the file stays with the author
- Source: https://github.com/data-goblin/power-bi-agentic-development/tree/HEAD/plugins/semantic-models/skills/semantic-model/SKILL.md
- Updated: 2026-10-28
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/semantic-model

## What it does

The skill manages tabular datasets by routing changes through a tiered tool cascade. It relies on the `te` CLI first for staging edits in memory: adding columns, relationships, measures, calculation items, and running Best Practice Analyzer checks. When certain properties cannot be updated via CLI flags, it escalates tasks to TOM scripts or a dedicated modeling MCP server, leaving raw TMDL modifications for structural bulk edits.

Formatting rules are strictly enforced: column references require single quotes and table names like `'Table'[Column]`, whereas measures must remain unqualified as `[Measure]`. Adding cross-table measures before the underlying relationship exists will cause the save validation gate to reject changes with `DAX0002`.

This setup focuses on data modeling, VertiPaq optimization, and AI preparation. Tasks regarding report canvas layout or visual formatting belong in `pbir-cli` instead.

## Requirements
- Works with: Power BI

## Install

### Claude Code (native platform)

1. **Plugin marketplace**
In the agent chat (not a shell):
```text
/plugin marketplace add data-goblin/power-bi-agentic-development
```
In the agent chat (not a shell):
```text
/plugin install semantic-models@power-bi-agentic-development
```
This installs the whole semantic-models plugin with all its skills

2. **Skills CLI (Vercel)**
```bash
npx skills add data-goblin/power-bi-agentic-development --skill semantic-model -a claude-code
```

3. **Manually: put the files in place**
- File: `~/.claude/skills/semantic-model/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/semantic-model/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add data-goblin/power-bi-agentic-development --skill semantic-model -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/semantic-model/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add data-goblin/power-bi-agentic-development --skill semantic-model -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/semantic-model/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install data-goblin/power-bi-agentic-development plugins/semantic-models/skills/semantic-model
```

2. **Manually: put the files in place**
- File: `.github/skills/semantic-model/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add data-goblin/power-bi-agentic-development --skill semantic-model -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/data-goblin/power-bi-agentic-development --path plugins/semantic-models/skills/semantic-model
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/semantic-model/SKILL.md` — The legacy .windsurf/skills/ path still works

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/data-goblin/power-bi-agentic-development/tree/HEAD/plugins/semantic-models/skills/semantic-model/SKILL.md

## When to use it
- Construct star schema relationships and calculation items
- Audit model quality against Best Practice Analyzer rules
- Configure incremental refresh and row-level security roles
- Shrink VertiPaq memory footprint for bloated tables
- Prepare model metadata and linguistic schemas for Copilot

## Example prompts
- Audit this tabular model against BPA rules and report issues
- Create a relationship from Sales to DimDate and define a standard measure
- Configure incremental refresh settings for the transactions table

## Similar
- [power-bi-model-design-review](https://affpapa.org/en/nevibecode/skills/power-bi-model-design-review.md) — skill · 9000 installs
- [Horizun PBI MCP](https://affpapa.org/en/nevibecode/mcp/horizun-pbi-mcp.md) — MCP server · ★ 34 repo stars
- [power-bi-dax-optimization](https://affpapa.org/en/nevibecode/skills/power-bi-dax-optimization.md) — skill · 9100 installs
- [Power BI Authoring MCP Server (Local)](https://affpapa.org/en/nevibecode/mcp/power-bi-authoring-mcp-server-local.md) — MCP server · ★ 1297 repo stars
- [power-bi-salespulse-360-dashboard](https://affpapa.org/en/nevibecode/skills/power-bi-salespulse-360-dashboard.md) — skill · 661 installs
- [power-bi-retail-analytics-salespulse360](https://affpapa.org/en/nevibecode/skills/power-bi-retail-analytics-salespulse360.md) — skill · 659 installs

From the same set: [data-goblin/power-bi-agentic-development](https://affpapa.org/en/nevibecode/by/data-goblin/power-bi-agentic-development.md) — 59 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
