# power-query

Drafts, inspects, and verifies Power Query M expressions in semantic model partitions while protecting query folding.

- 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/power-query/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/power-query

## What it does

The skill guides authoring and tuning M queries within Power BI semantic model import partitions. It structures steps like column selection and row filters so the underlying source executes them natively instead of pulling full datasets into engine memory.

Validation runs through two workflows. A fast syntax inspection happens when deploying partition changes via XMLA or TOM endpoints. Alternatively, running the included `examples/execute_m.py` against the Power Query API executes the mashup document on live sources and returns Arrow data.

Inspecting existing partition expressions and shared parameters relies on the `fab` CLI reading TMDL files.

## 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 power-query -a claude-code
```

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

### Codex

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

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

### Cursor

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

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

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

### Gemini CLI

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

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

### Windsurf (Devin Desktop)

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

## When to use it
- author M expressions for semantic model import tables
- prevent transformations from breaking SQL query folding
- validate M mashup logic against live data via API
- catch syntax defects prior to XMLA deployment

## Example prompts
- Optimize this M expression to ensure query folding stays intact
- Inspect the Orders table TMDL partition and fix broken steps
- Test this Power Query partition logic against the workspace API

## Similar
- [power-bi-salespulse-360-dashboard](https://affpapa.org/en/nevibecode/skills/power-bi-salespulse-360-dashboard.md) — skill · 661 installs
- [power-bi-retail-analytics-dashboard](https://affpapa.org/en/nevibecode/skills/power-bi-retail-analytics-dashboard.md) — skill · 384 installs
- [power-query-m](https://affpapa.org/en/nevibecode/skills/power-query-m.md) — skill · 114 installs
- [Power BI Data Modeling Expert Mode](https://affpapa.org/en/nevibecode/agents/power-bi-data-modeling-expert-mode.md) — subagent · ★ 41430 repo stars
- [power-bi-security-rls-best-practices](https://affpapa.org/en/nevibecode/rules/power-bi-security-rls-best-practices.md) — rule · ★ 41430 repo stars
- [Power BI Authoring MCP Server (Local)](https://affpapa.org/en/nevibecode/mcp/power-bi-authoring-mcp-server-local.md) — MCP server · ★ 1297 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
