Forum Discussion
Helper IIIDINAMIC SECURITY
I would suggest you set-up dynamic row level security - you would need to follow these steps
- create a table (i.e. T_Sec) with 2 columns UserID & Projects. The UserID should be the email used for the user to access to PowerBI
- in Desktop > Modeling> Manage Role, create a role, then in Table "T_Sec" of the "Manage Roles" view, in "Table Filter DAX expression" enter this DAX formula : [UserID] = USERPRINCIPALNAME()
- in Relationship view of Desktop, set-up the relationship (many-to-many) between the table T_Sec [Projects] to tables you want to limit visibility by projet
- then in Power BI Service, assign this role to the user and give them access
Please mark it if this works.
Solution SageHi Chema_Ortega ,
As M_L said, you need to set up Dynamic Row Level Security, there is a similar article here, you can also refer to :
Dynamic Row Level Security with Profiles and Users in Power BI : Many-to-Many Relationship
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IIIThanks a lot, Joesh. I am trying to fix everything up.
Best regards,
Chema