Forum Discussion
Problem with RLS on power bi service
Hello - i have just started using RLS and i have gotten it to work a few times, but this time i am running into issues. I have a model, containing a few tables, each with a column containing an e...
If you could show a sample, anonymized, of the tables, along with the roles created and the associated dax, I might be able to help, as we have been able to implement both RLS and dynamic RLS Thanks,
Sure, i can draw it out below.
Table 1 - Username/Email address
Username Email
Jane Doe [email protected]
Table 2
Order # (and other columns) Username Email
12345 Jane Doe [email protected] (merged from above)
Table 3 - pretty similar to table 2 with the email column merged to the end.
RLS In Desktop - I filter every table with the email address column using [Email] = USERPRINCIPALNAME()
RLS on Service - Go to dataset, security option, then add the users by email address.