I have a set of tables:
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.
Go to Solution.
I think you can refer to below article of dynamic rls:
Power BI – Dynamic Row Level Security – Tips to get it working!
View solution in original post
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!