Forum Discussion
yoismelp
4 years agoFrequent Visitor
Power BI Global Role Level Security
To any one reading this, I was wondering if you have come to a situation where you implement RLS on all of your reports (let say about 30). The RLS is set so that users assigned to site A Active Dire...
- 4 years ago
yoismelp . Have you create a table like
Site - Email and joined it with fact table (many to many bi-direction is fine too)
and then create a role with filter
[Email] = userprincipalname()
I think this approach should work
Assign this role to a security group
How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk
amitchandak
Super User
4 years agoyoismelp . Have you create a table like
Site - Email and joined it with fact table (many to many bi-direction is fine too)
and then create a role with filter
[Email] = userprincipalname()
I think this approach should work
Assign this role to a security group
How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk