Forum Discussion
row level security not working in app/web
Anonymous,
Based on your description, you want to achieve the requirement that user123 can see all rows but other users can only see their respective rows.
In your scenario, you can create two roles in Power BI Desktop, one for user123 without any filter applied which is called Admin, and another role for other users with filter by UserName(). There is an example for your reference, in the second screeshot, replace the DAX with “[Email] = UserName()”.
After you publish the report to Power BI Service, go to Dataset->Security, add email address of user123 under Admin role, add email addresses of other users under OtherUser role. When adding members to the role in Power BI service, you can type in the email address, or name, of the user, security group or distribution list you want to add. For more details, please review this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/ .Regards,
Lydia
I did some research and found that one probably has to activate Row Level Security in the respective Dataset in the PowerBI Service. There it is possible add Users or Groups to a Role. Is that correct?
However I would like the filter that I created in the Desktop app to apply to every single User! Is there a way achieve that without having to add every single user to that role?