Forum Discussion
RLS based on User Table
Hello everyone. I would like to add RLS to a PBI file by using one of the source tables as the user list. I have the following tables: I would like to use the User table to restrict or pr...
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.