Forum Discussion
Object Level Security "Reverse" Role
Hi JustDavid
If you have applied built-in restrictions on certain columns, non-HR users won’t be able to access them directly, which can sometimes cause errors in matrix visuals. To avoid this, you can either:
-
Remove the restricted columns from the matrix entirely for non-HR users.
-
Use role-based logic to conditionally display blank (e.g : Restricted) in those columns for unauthorized users.
Reference : Object-Level Security (OLS) with Power BI - Microsoft Fabric | Microsoft Learn
Hope this helps,
Thank You.-
Is there a way then for non HR users to be able to see the matrix table that I've created with the restricted columns "built-in", in a sense they are not able to see the "columns" without giving that error?
Hi JustDavid
If you have applied built-in restrictions on certain columns, non-HR users won’t be able to access them directly, which can sometimes cause errors in matrix visuals. To avoid this, you can either:
-
Remove the restricted columns from the matrix entirely for non-HR users.
-
Use role-based logic to conditionally display blank (e.g : Restricted) in those columns for unauthorized users.
Reference : Object-Level Security (OLS) with Power BI - Microsoft Fabric | Microsoft Learn
Hope this helps,
Thank You.
Hi JustDavid
We’d like to check if you were able to go through the previous response to your issue. Please let us know if you need further clarification we’ll do our best to support you.