---
name: powerbi-automated-semantic-model-drafting
description: Use when metadata, KPI contracts, or data contracts should automatically draft Power BI facts, dimensions, relationships, measures, roles, and model structure.
---

# Power BI Automated Semantic Model Drafting

Draft semantic models from validated requirements and metadata.

## Output Contract

- Candidate facts, dimensions, bridge tables, date roles, relationships, and grain.
- Measure catalog, calculation groups, RLS/OLS, refresh mode, and certification candidate.
- Source assumptions, unresolved keys, many-to-many risks, and validation tests.
- PBIP/TMDL handoff notes.

## Checks

- Do not draft certified models from unvalidated metadata.
- Flag mixed-grain risks.