# 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.

- 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/organize-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/organize-semantic-model

## What it does

This skill prepares tabular data models for business reporting and external analysis tools. It structures measures and attributes into display folders, groups tables by role, establishes drill hierarchies, and hides foreign keys and surrogate identifiers. Field names are normalized into readable Title Case, removing raw technical codes and storage prefixes.

Modifications run in passes through C# scripts using the Tabular Editor 3 MCP server or the `te` CLI against local TMDL definitions. Each script call represents a distinct undo step with a property diff. DAX editor tabs for target objects must remain closed during automation; running scripts against actively parsed tabs leads to an `IndexOutOfRangeException` in Tabular Editor.

Model architecture adjustments and DAX query tuning stay outside its scope. The MCP connection never writes changes directly to persistent storage, leaving commits to the user.

## 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 organize-semantic-model -a claude-code
```

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

### Codex

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

2. **Manually: put the files in place**
- File: `.agents/skills/organize-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 organize-semantic-model -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/organize-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/organize-semantic-model
```

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

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add data-goblin/power-bi-agentic-development --skill organize-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/organize-semantic-model
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/organize-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/organize-semantic-model/SKILL.md

## When to use it
- organize measures and columns into nested display folders
- standardize field names into clean business terms without prefixes
- configure natural drill paths across calendars and geographies
- hide technical columns and relationship keys from visual builders
- assign explicit sort-by columns for non-alphabetical labels

## Example prompts
- Tidy up the Date table and build calendar drill paths
- Organize display folders for the Sales table and hide surrogate keys
- Standardize table and column names to business Title Case

## Similar
- [powerbi-modeling](https://affpapa.org/en/nevibecode/skills/powerbi-modeling.md) — skill · 9934 installs
- [power-bi-model-design-review](https://affpapa.org/en/nevibecode/skills/power-bi-model-design-review.md) — skill · 9000 installs
- [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
- [DAX Terminal](https://affpapa.org/en/nevibecode/prompts/dax-terminal.md) — prompt · ★ 178201 repo stars
- [SemanticOps MCP (for Power BI)](https://affpapa.org/en/nevibecode/mcp/semanticops-mcp-for-power-bi.md) — MCP server · ★ 256 repo stars

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
