Forum Discussion
Check filtervalues based on USERPRINCIPALNAME()
In this scenario, you can define two roles in Row Level Security . One for those "general users" and apply dynamic row level filter on this table based on USERNAME(). The other one is for that "super user" without any row level filter.
Regards,
Yes I know I can do that. But for the superusers I also want their own department to be to only one to be displayed default. The other departments must be available in data, but not displayed when opening the dashboard....
MikeZZa, were you able to resolve this? I'm trying to implement the same thing and struggling how to set a default view based on the viewer but not restrict with RLS.
No. It's not possible (at the moment)....
You can vote for this on: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13926666-provide-username-function-in-power-query-m-or-da and then we'll have to wait.
