Forum Discussion
filter datasets for column
Hello dear Community, i'm looking for a way to display datasets only if their names are listed in specific columns. Let's say John S. is the Responsible of IT, then he only can list those dataset...
Anonymous Watch this video on RLS, and also the first comment by the video poster, you'll get your solution.
Well i found something useful from this article https://docs.microsoft.com/en-us/power-bi/service-admin-rls.
Right now im trying to build a email adress to compare, but since [Responsible of IT] = username() is giving back the UPN in Power BI Service i have two options.
1. to build an email adress from the full name llike [email protected]
2. Or to filter the name from the email which username() gives me back
Anyone got an idea how i could solve that?
Anonymous Watch this video on RLS, and also the first comment by the video poster, you'll get your solution.