RLS Switch kind of

[Victor_12]

Hello dear community,

I would like to know if there's a way to generate a button that allows the colleague to change from a global view report to a user view report, I'm thinking that maybe using the USERPRINCIPALNAME() to this button to turn the tables on the colleague data and after that unswitching to comeback at the global view, but I don't have it very clear yet how will this could work.

Regards

[audreygerred]

You can show users how to create a personal bookmark (and it can be set to be the default view if the user wants), so they can create a bookmark that is filtered to their specific data go to that as needed.

https://learn.microsoft.com/en-us/power-bi/consumer/end-user-bookmarks#types-of-bookmarks 

[Victor_12]

this is only available if they have editor access, right? because they only have view access and this can't be changed

[audreygerred · Accepted solution]

Nope it works for everyone - editing rights not needed - users can make multiple personal bookmarks. Also, I recommend sharing reports and dashboards via App connected to the workspace, not giving view access in the workspace (workspace should be for modeling/report developers/collaborators and app should be for report consumers: http://powerbiwithme.com/2024/01/02/the-principle-of-least-privilege-edition/