Forum Discussion
Helper IIFilter report by signed in user
I have a table with a user column that I want to display in power bi. However, I want to filter on this column to the currenlty signed in user, so that a person can see their own data only. Is there any way to make this work in Powerbi ?
agneum The following blog will help you in achieving your desired output - https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/dax-query-language-for-power-bi-and-power-pivot/userprincipalname-show-user-name-and-use-it-in-rls-dax-power-pivot-power-bi/#:~:text=Tutorials-,USERPRINCIPALNAME%20%E2%80%93%20show%20users%20name%20and%20use%20it%20in%20RLS%20(DAX,their%20own%20data%20(rows).
1 Reply
- AbbasG
Memorable Member
agneum The following blog will help you in achieving your desired output - https://exceltown.com/en/tutorials/power-bi/powerbi-com-and-power-bi-desktop/dax-query-language-for-power-bi-and-power-pivot/userprincipalname-show-user-name-and-use-it-in-rls-dax-power-pivot-power-bi/#:~:text=Tutorials-,USERPRINCIPALNAME%20%E2%80%93%20show%20users%20name%20and%20use%20it%20in%20RLS%20(DAX,their%20own%20data%20(rows).