Foreign-key column visible to report authors
"Foreign-key column visible to report authors" is one of the governance checks Auditabi runs on a Power BI semantic model. n column(s) on the many side of a relationship are visible. It is a low-severity finding: hygiene and maintainability, worth fixing when you next touch the object. Hide foreign-key columns on fact tables; expose the attribute from the dimension instead.
What is detected
n column(s) on the many side of a relationship are visible. Authors drop them into visuals and get meaningless IDs instead of the dimension attribute.
Why it matters
Hygiene and maintainability. Fix when touching the object.
How to fix it
Hide foreign-key columns on fact tables; expose the attribute from the dimension instead.
Reference
Tabular Editor BPA: Hide foreign keys
Does your model fail this check?
Free static audit with the exact objects, no account, nothing stored.