Forum Discussion

thampton's avatar
thampton
Icon for Helper III rankHelper III
7 years ago
Solved

RLS with username/email

Hello - i have an issue with RLS. First time using it, so might be a simple fix. I have a few tables in the model ALL which include a column that has an email address. (When i publish to PBI service,...
Need Help
Show and Tell
Tips and Tricks
  • jcarville's avatar
    jcarville
    7 years ago

    Are you assigning users emails to the roles in the security option of datasets in the service?

jcarville's avatar
jcarville
Icon for Skilled Sharer rankSkilled Sharer
7 years ago

thamptontry using USERPRINCIPALNAME() instead of USERNAME()

  • thampton's avatar
    thampton
    Icon for Helper III rankHelper III
    7 years ago

    I tried this and it still did not filter anything.

     

    I created a measure just to test, showing (user=userprincipalname) and this does show the correct email address (which matches what it in all the email columns) when published to power BI service.

    • jcarville's avatar
      jcarville
      Icon for Skilled Sharer rankSkilled Sharer
      7 years ago

      Are you assigning users emails to the roles in the security option of datasets in the service?

      • thampton's avatar
        thampton
        Icon for Helper III rankHelper III
        7 years ago

        This did help! I did not know you had to add them on the service as well. It worked for 2/3 users i am testing with. For some reason the one is added on service, and the email matches what is on the table, but no filter is applied.

         

        Thanks for the help so far!