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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
twister8889
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.

Data_table

Column1Column2Column3Key
Product1Category1Subcategory1Product1Category1Subcategory1
Product1Category1Subcategory2Product1Category1Subcategory2
............
Product2Category1Subcategory1Product2Category1Subcategory1

 

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?

 

User_table

KeyUser
Product1Category1Subcategory1User1@company.com
Product1Category1Subcategory2User1@company.com
Product1Category1Subcategory3User1@company.com

 

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

3 REPLIES 3
v-jingzhang
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:

https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi

https://radacad.com/dynamic-row-level-security-with-profiles-and-users-in-power-bi

 

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:
https://xxlbi.com/blog/configuring-all-access-with-dynamic-row-level-security/

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.