Skip to main content
skill CX Codex

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

Install into Claude Code · Plugin marketplace All methods and platforms ↓
/plugin marketplace add data-goblin/power-bi-agentic-development
/plugin install semantic-models@power-bi-agentic-development
Open on GitHub

What 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-development

This 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-code

3Manually: put the files in place

~/.claude/skills/power-query/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/power-query/

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.

Similar skills

All skills for Data and databases →

From the same set59

The whole set →
modifying-theme-json modifying-theme-json manages Power BI report themes via the pbir CLI: creates themes, changes palette and fonts, promotes visual formatting into the theme, clears local overrides. CX Codex +1 ★ 1,104repo stars creating-good-dashboards creating-good-dashboards enforces visual clarity and comment protocols when building or styling Claude dashboards, applying principles from Edward Tufte, Stephen Few, and Ben Shneiderman. CX Codex +1 ★ 1,104repo stars te2-cli The te2-cli skill helps Claude Code work with Tabular Editor 2 from the command line, from running scripts to checking and deploying models. Use it when automating Power BI model tasks. CX Codex +1 ★ 1,104repo stars python-visuals This skill guides an agent through adding Python visuals to PBIR Power BI reports and writing the matplotlib or seaborn scripts behind them. CX Codex +1 ★ 1,104repo stars r-visuals r-visuals is a Claude Code skill for creating R visuals, including ggplot2 statistical charts, in PBIR reports. CX Codex +1 ★ 1,104repo stars help-me-get-started help-me-get-started walks Power BI people new to coding agents through setup, explaining terms in plain language along the way. CX Codex +1 ★ 1,104repo stars semantic-model semantic-model guides tabular data modeling for Power BI and Analysis Services from the terminal across design, refresh, and review tasks. CX Codex +1 ★ 1,104repo stars deneb-visuals deneb-visuals is a Claude Code skill for building Deneb visuals and writing Vega or Vega-Lite specs in Power BI reports. It activates on Deneb mentions and questions about specs, interactivity, or rendering issues. CX Codex +1 ★ 1,104repo stars

Project sponsors

Companies that keep this analytics open