Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper V
Helper V

rls multiples values

Hi guys,


I have an RLS by three columns, and I am thinking in concatenate these columns as key.




I have a doubt, some users have access to all values, in my user table do I need to repeat the user for a lot of rows to each key, or has another way to indicate the user has access to all values?





In manage roles, I will use the User column with USERPRINCIPALNAME()

Community Support
Community Support

Hi @twister8889 


To my knowledge, as you are using the dynamic RLS, in your user table you will need to repeat the user for a lot of rows to each key. Or I will call it a Role table which is used to define data access level for every user. And actually it will form a many-to-many relationship between users and keys. Please refer to below link for more guide about this:


Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.

First of all, thank you for your answer..


I found this post, what do you think about this:

@twister8889 Thanks for sharing this link. It's a great blog. I think I need to dig deeper into RLS and DAX.

Helpful resources

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors