pbi_validate_star_schema
Validates a Power BI semantic model's star schema by detecting fact, dimension, bridge tables, snowflake violations, and fact-to-fact constellations. Supports optional fact table hints for incremental models.
Instructions
Confirm a model follows star schema topology.
Heuristic: a fact table participates as the many-side in ≥1 relationship, a dimension table participates as the one-side. Tables that are both are flagged as bridge tables. Direct dimension-to-dimension relationships are flagged as snowflake violations. Fact tables wired to other facts are flagged as fact-to-fact (constellation).
Optional fact_table_hints lets callers force-tag tables as facts
(matched case-insensitively); useful when a fact table has no incoming
relationships yet because the model is being built incrementally.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| include_hidden | No | ||
| fact_table_hints | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |