[Rule Request] Hide foreign key columns

[lbeneyze]

Good morning,

Firstly, I really like the effort the communities to elevate the Power BI development level. Keep up the good job.
I'm trying for the first time the BPA and struggling with the rule "Hide foreign key columns". I'm also new to LINQ.
I've paste the below formula found here (https://docs.tabulareditor.com/Best-Practice-Analyzer.html#fixing-objects)
"Model.Relationships.Any(FromColumn = outerIt) and not IsHidden and not Table.IsHidden"
and I got the error message "Operator '=' incompatible with operand types "Column" and Model""

Thanks in advance for letting me know.

Kind regards,
Lohic Beneyzet

[m-kovalsky]

You must select the appropriate objects within the 'Applies to' dropdown in the 'Edit Best Practice Rule' window. 'Model' is checked by default so you must uncheck it in this scenario (since this rule should apply to columns only). This rule should apply to 'Calculated Columns', 'Calculated Table Columns', and 'Data Columns'.