Relationship on text keys
"Relationship on text keys" is one of the performance checks Auditabi runs on a Power BI semantic model. n relationship(s) join on string columns. It is a medium-severity finding: the model still works, but results are wrong in some filter contexts, slow, or fragile under change. Where the key is naturally numeric, store it as int64; otherwise accept the cost on small dimensions only.
What is detected
n relationship(s) join on string columns. Text keys need a dictionary lookup on every join; integer surrogate keys are smaller and faster.
Why it matters
Severity depends on how many objects are affected.
How to fix it
Where the key is naturally numeric, store it as int64; otherwise accept the cost on small dimensions only.
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.