Forum Discussion
Dynamic Row Level Security with Report User Access in Power BI
I have few tables and has relationship shown below.
How can I apply RLS so at to filter through useremail or user when user log in and by seeing only when the user have access right like owner, admin and member?
For example, when user has access right for Owner, ReadCopy, ReadReshare and ReadWrite then their role is 1, then they can see all users data including other user activities in that particular report.
On the contrary, if the user only has right for Read, then their role is 0, then they are not able to see any information relate to the report.
So when John logs in to the pbix, based on reportusers tables that show John is role 1 for specific reports he should be able to see all information in those reports.
If Alex can just read the report, which is role 0, then Alex couldn't see any data related to that report.
I have tried to create RLS on manage role using this below:
[identifier] = userprincipalname() && [role] = "1"
It works correctly on the workspace and reports that they have the access right. But the user activity data does not work correctly. Some of the activities of the users in the reports are hidden when i use this dax expression.
Please help.
Thanks
RLS is ignored for anyone who has workspace access above Viewer level.
1 Reply
- lbendlinSuper User
RLS is ignored for anyone who has workspace access above Viewer level.