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.
My task to do on Power BI report is relatively simple: mask one column with blank or "***" when the user doesn't have enough permissions to see it.
Everything works well when I am looking at the data in Desktop with View As feature:
I filter table A based on email on table B to get the team Id, only one per user. Table B has all team members. Table C then change one id to another id. And table D has nothing but user ids and the column I wish to mask. And this works in Desktop: I only see those rows I am supposed to see.
But problems start after that:
- I can't make an active connect from the filtered "sensitive data" table to the main table Issues as then issues table would be filtered.
1) So I create non-active connection instead and create a calculated column to Issues:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @TimoRiikonen ,
When you set up security Roles in Power BI Service, did you confirm that the user does not have edit permissions in this workspace?
If the user is a role other than viewer in the workspace, then RLS is no longer in effect for them.
Best Regards,
Community Support Team _ Caitlyn