Relationship pointing from a dimension to a fact
"Relationship pointing from a dimension to a fact" is one of the modeling checks Auditabi runs on a Power BI semantic model. n relationship(s) are declared with the dimension on the many side and the fact on the one side. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Declare the relationship from the fact (many) to the dimension (one).
What is detected
n relationship(s) are declared with the dimension on the many side and the fact on the one side. Filters then flow from the fact to the dimension, which is the opposite of what report authors expect.
Why it matters
Wrong in some filter contexts, slow, or fragile under change. Fix in the next iteration.
How to fix it
Declare the relationship from the fact (many) to the dimension (one).
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.