how to filter based on user login

[daniellanuza]

hi

I know this was not available, but now we have this new role feature maybe it is.

anyonhe tried to create a report taht will filter based on the user login?

basically i have a standard report and would want anyone to have his personalized view, without having to create 1 report for each person

thanks

[samdthompson]

Hi,. You need a table of all user names (and email address's). Use the DAX formula =USERNAME() to filter user access.

[daniellanuza]

hi thanks for the reply

assuming i have that table (which i can get) how do i make it work?

where should i use the formula?

i currently just use a slicer with the user -- manually set, of course- and i hoped i can automate that selection

help appreciated

[TOK]

I've got the same problem.

I have a user list from an active directory connection and created a measure showing the current report user using DAX USERNAME().

But how can I filter my user table by username()?

[achinm45]

hi @samdthompson

Have you tried on Power Bi service ?

It did not  work on power BI service for me.

BR

[samdthompson]

Hi, yes it works on service, you do need to share the model with people but as long as they are listed on the user table you are fine. Are you able to post some more speficics of your model? I suspect there is some other fishook getting in the way. 

[vickyprudhvi]

Hi,

i was able to do it using SSAS tabular model. But still we need list of username in a table.