check_relationships
Diagnose blank Power BI visuals by identifying dimension members without matching fact rows and unmatched fact keys, revealing why slicer selections render empty.
Instructions
Diagnose 'the visual is blank' issues: for every Fact->Dim relationship, count dimension members that have NO matching fact rows (these render BLANK when a user selects them in a slicer - the #1 cause of an apparently-broken visual) and fact keys with no dimension match. Run this whenever a visual is empty but the model 'looks fine'.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sessionId | Yes |