Forum Discussion
Solved
Row Level Security not working
Hello, I've created a report and, in Desktop, I've created several roles relating to the different groups within the report and an "Exec" role to give Executives a view of all. I've filtered the...
PBIUSER3 Yes, I ended up using Dynamic RLS to fix the problem. Our PBI login matches ID's in the data, for example:
Login: [email protected]
Data: UserID- UserBob123; Customer-ABEX; Order#-7524
I then used a filter in the role like: UserPrincipalName()=Concatenate(UserID,"@microsoft.com")
Hope that helps!
PBIUSER3 Yes, I ended up using Dynamic RLS to fix the problem. Our PBI login matches ID's in the data, for example:
Login: [email protected]
Data: UserID- UserBob123; Customer-ABEX; Order#-7524
I then used a filter in the role like: UserPrincipalName()=Concatenate(UserID,"@microsoft.com")
Hope that helps!