Forum Discussion

marquesj's avatar
marquesj
Regular Visitor
2 years ago

RLS rules not working

Hi,

 

I have a team with ~60p and I created a dashboard where the team's KPI can be checked. I want to share it with the team, but I only want them to have access to their own results. 

 

I created a table ("Users") with a column with their Name and created a connection in model with the data (Name-Name). Then I created a rule role called "Restricted View" and on the "Users" table I put this DAX: Users[Name] = USERNAME()

 

From what I've read this would be enough to filter based on the username the login into the dashboard, but when trying with 1 user, the dashboard shows blank.

 

Any help please?

 

Thanks in advanced

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi marquesj ,

     

    Both USERNAME() and USERPRINCIPALNAME() return email format on the service, make sure your name column is a value in this format. You can check the results as follows:

     

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.