菜单
Edit the Power BI semantic model as code by authoring TMDL files in a PBIP project (offline, Desktop closed). Covers structure, syntax, and post-edit verification.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Use when the user wants to create, add, extend, or modify an agent, skill, or workflow in this kit (e.g. "create a skill for our dbt naming standard", "add an agent for X", "new workflow"). Decides whether to build an agent, a skill, or nothing, enforces lean quality standards, and keeps every installed AI-tool folder (.agent, .claude, .github, .opencode, AGENTS.md) identical in each tool's native format.
Use when the user wants to build a presentation, deck, slides, pitch, readout, or interactive report from data work — exploratory analysis, dashboards, business plans, proposals. Covers as-code HTML formats (reveal.js deck, flexible scrollable deck, interactive site, consulting-style PDF, Marp) plus a chart cookbook, how to choose between them, and ready-to-edit starters. Default engine is reveal.js. For native editable PowerPoint use the generating-pptx skill.
Use when the user needs an EDITABLE PowerPoint (.pptx) deliverable — "make a PowerPoint", "export to PPTX", "editable slides", "send me a .pptx". Generates native, fully editable PowerPoint (real text boxes, shapes, native charts with embedded data, tables) via python-pptx — not images. Brand colors map from DESIGN.md. For HTML decks/sites/PDF use building-html-presentations instead.
Validate a Power BI semantic model with the real Best Practice Analyzer (BPA) via the free Tabular Editor 2 CLI, using a shareable BPA rules file.
Use when the user wants output to follow a company's brand / visual identity, or asks to set one up — "use our brand", "make it on-brand", "here's our identity", "create a DESIGN.md". Reads and applies a DESIGN.md (Google Labs open spec): brand tokens for colors, typography, spacing, radius, shadows, and components, so decks, sites, and docs come out consistently on-brand. Scaffolds a DESIGN.md when none exists.
Use when the user asks to document, write docs for, or generate a runbook, data dictionary, metric definition, ADR, or Power BI dashboard catalog for a data project. Provides the team's canonical documentation templates as separate files.
| name | pbi-semantic-layer-tmdl |
| description | Edit the Power BI semantic model as code by authoring TMDL files in a PBIP project (offline, Desktop closed). Covers structure, syntax, and post-edit verification. |
Author and edit the semantic model (tables, columns, measures, relationships, RLS) by writing TMDL files directly. TMDL is the GA, human-readable text format for tabular models — great diffs, one file per table, fully scriptable.
Power BI Desktop must be CLOSED before saving. Desktop keeps the model in memory and overwrites disk on save, so editing live corrupts files or loses work.
.SemanticModel structure<Project>.SemanticModel/
definition.pbism ← pointer (do not hand-edit)
definition/
model.tmdl ← model-level definition, lists tables
database.tmdl ← compatibility level / annotations
tables/<Table>.tmdl ← ONE table per file (golden rule)
relationships.tmdl ← all relationships
expressions.tmdl ← shared M expressions / parameters
cultures/ ← translations
roles.tmdl ← RLS
.pbi/ ← local cache/settings — NEVER edit (localSettings.json, cache.abf)
Edit .tmdl files only. One table per file — never define every table inside model.tmdl.
table 'Sales'
description: "Primary sales fact."
measure 'Total Sales' = SUM(Sales[Amount])
formatString: "#,##0.00"
displayFolder: "Financials"
description: "Sum of sales amount."
column 'Amount'
dataType: decimal
sourceColumn: BaseAmount
relationship Sales_Date
fromColumn: Sales.DateId
toColumn: Date.DateId
fromCardinality: many
toCardinality: one
Serialization rules: keep functional properties (dataType, sourceColumn) before
cosmetic ones; match the file's existing indentation; for multi-line DAX, break with \ at the
end of the line.
.SemanticModel folder, validate, batch-edit, and
re-serialize clean TMDL. Use it to sanity-check non-trivial edits.powerbi-modeling-mcp (preview) edits the same PBIP/TMDL files and
is handy for bulk operations. File editing remains the default, accessible path..pbip in Desktop and wait for the field list to populate.pbi-quality-rules skill (BPA) after significant changes.