Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
I have an RLS by three columns, and I am thinking in concatenate these columns as key.
Data_table
Column1 | Column2 | Column3 | Key |
Product1 | Category1 | Subcategory1 | Product1Category1Subcategory1 |
Product1 | Category1 | Subcategory2 | Product1Category1Subcategory2 |
... | ... | ... | ... |
Product2 | Category1 | Subcategory1 | Product2Category1Subcategory1 |
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
Key | User |
Product1Category1Subcategory1 | User1@company.com |
Product1Category1Subcategory2 | User1@company.com |
Product1Category1Subcategory3 | User1@company.com |
In manage roles, I will use the User column with USERPRINCIPALNAME()
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |