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 Everyone,
I'm struggling trying to extract all emails added from Row Level Security section per each role. We have several emails (+2000).
You may know some trick to extract them as csv or another extension.
Thank you in advance.
Solved! Go to Solution.
HI @Anonymous,
I'd like to suggest you create dynamic RLS roles based on username, it should reduce the workload and complexly on RLS settings. Please check the blog(written by GilbertQ) that mention in the following link to help you clarify the dynamic RLS role setting.
Notice:
1. RLS with username does not mean you had to set the filter on usernames, it also can be work to use the current username to look up corresponding fields and apply filters if you configure on the user mapping table. (e.g. city, region, gender)
2. RLS roles also can be assigned with a group instead of manually dispatch to each user. (use security group)
3. If you only want to export the user list that accesses the content, you can check the following link:
Access to App Workspaces and list of users who have access
Regards,
Xiaoxin Sheng
HI @Anonymous,
I'd like to suggest you create dynamic RLS roles based on username, it should reduce the workload and complexly on RLS settings. Please check the blog(written by GilbertQ) that mention in the following link to help you clarify the dynamic RLS role setting.
Notice:
1. RLS with username does not mean you had to set the filter on usernames, it also can be work to use the current username to look up corresponding fields and apply filters if you configure on the user mapping table. (e.g. city, region, gender)
2. RLS roles also can be assigned with a group instead of manually dispatch to each user. (use security group)
3. If you only want to export the user list that accesses the content, you can check the following link:
Access to App Workspaces and list of users who have access
Regards,
Xiaoxin Sheng
Hi there
Could you give more details around what you mean by extracting emails from Security section?
Yes, as we only see microsoft user name in RLS instead of emails, that's why I want to extract the emails from those list. I have 6 roles and in each one we have more that a thousand user added and for example:
My email could be example.other@gmail.com
but in row level security section appear like OTHER, EXAM(CITY)
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.