| name | mcp-engine-schema-authoring |
| description | Plan and execute Power BI physical model changes. Use when creating or updating tables, columns, relationships, hierarchies, calendars, partitions, or refresh strategy, especially when changes may affect dependencies, data shape, or refresh behavior. |
PBI Schema Authoring
Use this skill for physical model structure work. Keep schema edits explicit, ordered, and dependency-aware.
Safe edit order
- Inspect the current schema and dependency surface before editing.
- Choose the correct schema area: table or column shape, relationships, hierarchies, calendars, or partitions.
- Validate downstream impact before destructive changes.
- Prefer a dry run or checkpoint when the change touches many objects.
- Re-check refresh implications after the structural edit lands.
Branch by task
Tables and columns
- Read column-and-table-authoring-guide for create, update, rename, and delete flows.
- Use it when the user changes schema shape, visibility, formatting, or date-table marking.
Relationships
- Read relationships-guide before adding, removing, or changing relationships.
- Re-check filter direction, inactive relationships, and ambiguity before applying the change.
Hierarchies and calendars
Partitions and refresh
Guardrails
- Check dependencies before deleting or renaming objects that may be referenced elsewhere.
- Keep schema changes separate from semantic rewrites unless the task explicitly requires both.
- Confirm destructive changes and large refresh-impacting edits before execution.
- Re-run targeted validation queries after relationship or partition changes.
References
