SKILL.md
/power-bi-build
Build IPPF-branded Power BI artefacts. v1 scope: writes DAX measures into the semantic model via the pbi CLI; writes the IPPF theme JSON into the .pbip folder directly; saves page recipes (indicator dashboard, equity, methodology) as JSON staging artefacts the user applies manually in Power BI Desktop. Full page-and-visual automation is v2.
Tooling reality
The pbi CLI (package pbi-cli-tool, command name pbi) wraps a Power BI MCP server for semantic model operations only:
- ✅
pbi measure create— add DAX measures. - ✅
pbi table,pbi column,pbi relationship— model structure. - ✅
pbi dax— execute and validate DAX. - ❌ No
pbi themecommand. Theme JSON is written directly to the.pbipfolder. - ❌ No
pbi pageorpbi visualcommand. Pages and visuals are created manually in Power BI Desktop using the staging recipe JSONs as a guide.
When the upstream tool adds report-layer commands, this skill will absorb them. v1 ships with the scope above.
Two routes. The v1 flow below (pbi CLI for measures + theme + staged page recipes) suits an existing model the user keeps building by hand. When the source is an Excel workbook and the user wants a complete, working dashboard handed over (data loaded, measures, theme, and report pages all built), use the full .pbip authoring route in the dedicated section below instead. That route was validated end-to-end (CERV Portfolio Dashboard, 2026-06-20).