RLS on a dimension

Hi vp84 
You need to create a table with roles by BU .
The columns: User Name, Bu
And to create a relationship by BU with your data tables ( it will be many to many and its ok in this case).

For more information please refer :

https://community.fabric.microsoft.com/t5/Desktop/Dynamic-RLS-by-group/td-p/1378126

(in your case BU is like school in the linked discussion)

Or you can create a BUs table with unique values and use it as a "bridge"

:https://www.youtube.com/watch?v=Z3oLWtWABfo

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Hi again 🙂

This functionality is the same as all other dims, it gives you the flexibility to connect multiple tables and filter them in an efficient way + If we are talking about data that can be changed like employees who can leave it is much easier to manage roles table.

(like other RLS systems not just PBI )

If you have just 1 static table you can try to use its columns, but it is not the best practice.