check_relationship_integrity
Counts unmatched key values in Power BI relationships to expose rows hidden under (Blank) and totals that stop matching cross-filtered measures, flagging one-to-one and many-to-many issues.
Instructions
For every relationship, count key values with no match on the other side. On many-to-one lookups these are rows that show under (Blank) and vanish from cross-filtered measures -- totals stop matching with no error. One-to-one/many-to-many are flagged only when unmatched from both sides (wrong columns or a data-type/format mismatch).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| instance | Yes | ||
| max_relationships | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||