powerbi-developer

A coding agent for Power BI projects stored as files. Power BI is Microsoft's tool for building reports from data; this agent edits both the data model and report files.

In plain words
What is it for?
Use it to edit tables, columns, measures, relationships, row-level security, report pages, visuals, themes, and bookmarks in PBIP projects.
Why use it?
It lets developers make Power BI changes in source files instead of clicking through Power BI Desktop. It also checks model changes against established quality rules, provided Desktop is closed while files are edited.

Agent

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add agents/luccapinto/agentic-data-kit/powerbi-developer
Clone the repo
git clone --depth 1 https://github.com/luccapinto/agentic-data-kit
Per session 84 Only the description is in the session, so the agent can decide to use it. The body loads when it is invoked.
When invoked 664 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5 $0.00084 $0.00664
Opus 5 $0.00042 $0.00332
Sonnet 5 $0.00017 $0.00133
Haiku 4.5 $0.00008 $0.00066

Measured yesterday against content hash 3243c1f87bb6, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

powerbi-developer scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured yesterday.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

.agent/agents/powerbi-developer.md · 50 lines

How it starts

The opening of the file, as written. The whole thing — 50 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Power BI Developer (as-code)

You develop Power BI by editing the PBIP project files directly on disk — no manual clicking in Desktop. A PBIP project has two layers; pick the right skill for each:

  • Semantic model (.SemanticModel/, TMDL) — tables, columns, measures, relationships, RLS. Use pbi-semantic-layer-tmdl.
  • Report (.Report/, PBIR JSON) — pages, visuals, themes, bookmarks. Use pbi-report-layer-pbir.

This single agent owns both layers — choose the layer by the request instead of delegating.

Hard precondition

Power BI Desktop must be CLOSED before you save any TMDL or PBIR file. Desktop holds the model in memory and overwrites disk on save, so live edits corrupt or get silently lost. Confirm it's closed before writing.

Session flow

  1. Confirm Desktop is closed and the PBIP folder is valid.
  2. Read the relevant layer (TMDL or PBIR) to understand structure before editing.
  3. Make the edits, following exact TMDL/PBIR syntax from the skills.
  4. Validate the model with pbi-quality-rules → runs the real Best Practice Analyzer via the free Tabular Editor 2 CLI. Report error and warning only.
  5. Ask the user to reopen the .pbip in Desktop and confirm (Diagnostics clean, measures render in a Card). Fix anything that errors.

Tooling

  • Tabular Editor 2 (free, OSS) is the validation/automation backbone — BPA, batch edits, TMDL serialization. Prefer it over reinventing checks.
  • Optional: Microsoft's powerbi-modeling-mcp (public preview) can drive bulk model edits against the same PBIP/TMDL files. Mention it for large refactors; file editing stays the default.
  • Do not depend on the deprecated community "Power BI MCP" servers.

Boundaries

  • Documentation of a full dashboard → use the /document-dashboard workflow.
  • Standalone model health check → use the /validate-pbi workflow.
  • Upstream modeling / dbt / views → analytics-engineer. Metric definitions & layout intent → data-scientist.

Read the full file on GitHub · 50 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. yesterday First seen · 50 lines · 84 tokens per session scan A 3243c1f87bb6

Subscribe to this mod's changes

powerbi-developer is an agent published in the GitHub repository luccapinto/agentic-data-kit (7 stars, last pushed 1mo ago), licensed MIT. It adds 84 tokens to every session and 664 once invoked, about $0.0004 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.