Forum Discussion
New to RLS
Hi MyWeeLola ,
Based on your description, and the solution provided by Miguel, I created a pbix file for your reference.
This RLS is dynamic, it will dynamically filter the table based on the current user's userprincipalname, and return the empty set when there is a user that is not in the contained domain.Note that a Role RLS that has Edit or higher permissions on the semantic model will not take effect, so these users need to be assigned as Viewers.
Power BI implementation planning: Report consumer security planning - Power BI | Microsoft Learn
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
MFelix Thank you for replying. I think that either I am misunderstanding your response or I have not entered what I need correctly
I have a table with a column which has companies, Apple, Banana and Chocolate.
I have created a role called Apple, which filters my table and only shows Apple, I've created 2 other roles, one for Banana and one for Chocolate. I did this under manage roles in the desktop version.
I have now uploaded that to my workspace and then in the security section, I want someone with the username @Apple.com to be placed in the first security role, and so forth. The code you send me extracts the domain name in the desktop version, how do I apply that in the service? Essential, all I want is for someone with [email protected] to only see the filtered Apple information or [email protected] to only see the filtered banana. Does that make sense?
Thank you for being patient with my response
Lola
