power-query — Claude Code skill: what it does, how to install
Drafts, inspects, and verifies Power Query M expressions in semantic model partitions while protecting query folding.
GPL-3.0 ★ 1,104 updated 2026-10-28
/plugin marketplace add data-goblin/power-bi-agentic-development
/plugin install semantic-models@power-bi-agentic-developmentWhat power-query 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.
What it helps with
- 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 for the agent
- 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
How to install power-query
1Plugin marketplace
/plugin marketplace add data-goblin/power-bi-agentic-development/plugin install semantic-models@power-bi-agentic-developmentThis installs the whole semantic-models plugin with all its skills
2Skills CLI (Vercel)
npx skills add data-goblin/power-bi-agentic-development --skill power-query -a claude-code3Manually: put the files in place
~/.claude/skills/power-query/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/power-query/
1Skills CLI (Vercel)
npx skills add data-goblin/power-bi-agentic-development --skill power-query -a codex2Manually: put the files in place
.agents/skills/power-query/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add data-goblin/power-bi-agentic-development --skill power-query -a cursor2Manually: put the files in place
.cursor/skills/power-query/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install data-goblin/power-bi-agentic-development plugins/semantic-models/skills/power-query2Manually: put the files in place
.github/skills/power-query/SKILL.md1Skills CLI (Vercel)
npx skills add data-goblin/power-bi-agentic-development --skill power-query -a gemini-cli2Platform CLI
gemini skills install https://github.com/data-goblin/power-bi-agentic-development --path plugins/semantic-models/skills/power-queryManually: put the files in place
.devin/skills/power-query/SKILL.mdThe legacy .windsurf/skills/ path still works
Claude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about power-query
How to install power-query in Claude Code?
Run /plugin marketplace add data-goblin/power-bi-agentic-development first, followed by /plugin install semantic-models@power-bi-agentic-development.
What does power-query do?
It assists with writing, debugging, and testing Power Query M code for semantic model partitions, with an emphasis on preserving source query folding.
How does the skill test M code against real sources?
It wraps the mashup query in a section document and triggers POST /v1/workspaces/{wsId}/dataflows/{dfId}/executeQuery, then inspects the resulting Arrow payload.