cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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 datasets where he's listed in the column Responsible of IT. I don't want to use roles, since i have to manage every single Person with his role.

 

Thank you!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@Anonymous Watch this video on RLS, and also the first comment by the video poster, you'll get your solution.

 

https://www.youtube.com/watch?v=9wN33rTaiB4

View solution in original post

5 REPLIES 5
v-cherch-msft
Microsoft
Microsoft

Hi @Anonymous

 

Based on my research, it seems there is no better way to do that. For your requirement, you may submit an idea here.

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

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 John.Wayne@outlook.com

2. Or to filter the name from the email which username() gives me back

 

Anyone got an idea how i could solve that? 

Anonymous
Not applicable

@Anonymous Watch this video on RLS, and also the first comment by the video poster, you'll get your solution.

 

https://www.youtube.com/watch?v=9wN33rTaiB4

View solution in original post

Anonymous
Not applicable

Well i did a workaround with building an emailadress from the Responsible name in an extra column with the help of DAX. Thank's to everyone for helping out.

Hi @Anonymous

 

Here are some articles for your reference. 

Using Username() in DAX with Row-Level Security

 

https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/

http://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.