Forum Discussion
Data Labels with Security Policy
Dear all, I would like to present all up data in Power BI, however data will show data of our partners, that are competitors. We dont want to show Account Manager of partner "AAA" data of partner...
Hi JorisVoorn
I believe you can use RLS to achieve this. Create 2 roles, "All Access View" and "Limited Access View". For All Access View, you can leave it as it is. For Limited Access View, you can create a filter expression in the "Manage Roles" function that does something like this: If Table[Partner] = "AAA" then "AAA" else "Others"
I am not entirely sure about the syntax but that's the logic of it.
When you publish this up to Services, remember to assign everyone that has access to the report the roles they should have, else, they will not be able to view the visual.
Hope this helps!
Daren
Sorry but my issue was still not resolved, so could any moderator please uncheck topic as solved and unmark this reply as solution?