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 Friends,
I have set up RLS based on the user email_id as [Email] = USERPRINCIPALNAME() . In order to get it work i have created a dataset containing the useremail list along with their sales area and than created another table call Sales area where i have created many to one relationship on my emailID dataset. After i publish my dashboard i also need to add all the email ID which i have alread listed on my dataset under dataset-->security option.
What i know is thats a dynamic approach but if it is Dynamic ,why you have to add emailID in security section,once he login power bi should know the user from his login ID and show him the region he belongs ? i mean if i have 50 users do u want me add those 50 users,then it is not dynamic right,can you please help to configure dynamic security in power bi.
Thanks, any help much appriciated.
Solved! Go to Solution.
Well, RLS works by putting users in roles. But, have you seen this article:
The Row-level security (RLS) rule with Power BI only worked in my case when in Workspace I define that users have only Viewer access.
Well, RLS works by putting users in roles. But, have you seen this article:
Thanks Greg, Much appriciated.
Kind Regards,
Biswa
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |