Forum Discussion
RLS based on User Table
It's resolved! The issue was the DAX function: is not USERNAME(); is USERPRINCIPALNAME().
Hi Anonymous ,
Does RLS work for table User (2)? Please make sure the [Username] column is in format. What are the relationships between your tables? Are they Single or Both? If they are Both, make sure "Apply security filter in both directions" is selected.
If these could not work, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello huojiami,
Unfortunately none of the above worked. I used both user tables (in different samples) as the filter table for RLS but neither attempt worked.
I couldn't attach a copy of the file, so I'm sending you prints of the tables, contents, and relationships. I appreciate your help.