build-power-bi-report

Build a Power BI Report

This plugin ships two MCP servers — pbi-model (semantic model / TMDL) and pbi-report (report / PBIR) — that edit a .pbip project directly on disk. Every write is atomic, backed up, and pre-flight validated against the official Fabric schemas, so you cannot corrupt the project.

Always do this first

Call pbi_set_project(path) on the server you're using (each server tracks its own project). Point it at a .pbip file or the project folder. Then call pbi_capabilities() once to load the exact visual types, buckets, and filter kinds — don't guess bucket names, read them.

The default is BUILD, and the fastest path is scaffold

Prefer building over interrogating the user. Scale questions to scope:

Request	What to do
"Build me a report" / broad	pbi_scaffold_report(dry_run=true) → show the proposed pages → build
A specific page (KPIs + charts)	pbi_build_designed_page(...) in one call
One or a few visuals on a page	pbi_add_visual / pbi_build_page
One visual, one property	Just do it

pbi_scaffold_report — the autopilot

One call profiles the model (fact/dimension/date tables, measure roles, grouping columns) and builds a themed, navigable, multi-page designed report: an overview page (KPI strip on backplates + trend + breakdown + table) plus per-dimension detail pages with a nav bar. Use dry_run=true first to return the proposal so the user can edit it, then run it for real. Pass accent="#RRGGBB" for their brand color.

pbi_build_designed_page — one designed page

pbi_build_designed_page(name, title, subtitle?, kpis, charts, accent?).

• kpis: [{"measure": "Table.Measure", "title": "..."}]
• charts: normal visual specs (positions auto-laid-out on a 12-col grid)

It composes a header band, a KPI strip on rounded backplates, and a chart grid.

Binding grammar (for pbi_add_visual / pbi_build_page)

{ "visual_type": "clusteredBarChart",
  "bindings": { "Category": ["Date.Year"], "Y": ["Sales.Revenue"] },
  "title": "Revenue by Year" }

• Buckets are per-visual-type — get them from pbi_capabilities(). The Legend role is the Series bucket; combo charts use Y + Y2; donut has no Category.
• Aggregate a column inline: "Sum(Sales.Amount)", "Average(...)".
• Measures vs columns are resolved automatically.