Forum Discussion
Dynamic RLS
Hi, Say like 2 tables. 1 is fact with unique accounts and its transactions. 2 is accountid and email ids. an account can be shared with multiple users, so table 2 will have many records. F...
Let the data model do the work. Link the tables, make sure the filter direction is pointing from accounts to transactions, and put the RLS on the accounts table with a simple formula:
[Emailid]=USERPRINCIPALNAME()
Hi Anonymous ,
See if these help.
https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi
https://radacad.com/show-the-information-but-not-the-details-power-bi-data-masking
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi Harsh, i tried thise radcad blogs, my scenario is not suited however as you see above measures with filter condition, i tried similar to those blogs.