Forum Discussion
RLS - Need Help
I have a set of tables:
User table:
UserID USerName
======= ========
A AAA
B BBB
C CCC
Region table:
Region_ID Region_Name
======= ==========
1 Reg1
2 Reg2
3 Reg3
4 Reg4
Access_Details table:
Region_ID User_ID
======= ========
1 A
1 B
2 B
Details table:
Region_ID Date Status Flag
======= ======== ===
1 xyz 1
2 abc 1
1 abc 1
I need to limit access based on the User_ID. I tried creating a role on User table by specifying [User_ID]=UserName()
When i used "View as Role" and specified User_ID as A, nothing gets filtered.
- Anonymous9 years ago
Hi vanessa,
I think you can refer to below article of dynamic rls:
Power BI – Dynamic Row Level Security – Tips to get it working!
Regards,
Xiaoxin Sheng
1 Reply
- AnonymousNot applicable
Hi vanessa,
I think you can refer to below article of dynamic rls:
Power BI – Dynamic Row Level Security – Tips to get it working!
Regards,
Xiaoxin Sheng