Direct Lake: “relationship needs to be recalculated” Is a Refresh You Forgot
Symptom
I added relationships to a Direct Lake semantic model. Queries then failed with a message that said, in substance, that a relationship needed to be recalculated. I only noted it as “relationship…needs to be recalculated”, so I can’t give you the full string.
Cause
Adding relationships to a Direct Lake model does not leave it query-ready. The model has to be reframed first. The message reads like a problem with your relationship, but nothing was wrong with mine. The model simply had not been refreshed since I added them.
Fix
Run a refresh on the semantic model. I did it with Refresh now from the workspace list. For a Direct Lake model that refresh is the reframe.
My advice: after you add relationships, refresh before you test anything.
How I Proved It
I hit this while building the model: 13 tables, 21 relationships and 53 measures. The last change I verified was a late relationship, which I refreshed and then confirmed Active under Manage relationships.
What I did not do is capture a clean before-and-after of one query failing and then passing. My DAX query editor would not stay open during that work, so the evidence is that refresh and the relationship dialog, not a recorded query result.