Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Need to show records which are related to logged in user based on User Teams

Hai All, 


I created a power bi report and i want to show the data which is related to logged in user. I gone through some of the articles. But, here the scenario is something different than others. Let say A is Table and the owner of the A table will be the Team then Team is associated with User.


If A table is having 2 members then that two members are the part of that team. At last i want to show only logged in user records in the report.

Can someone help me on this please. 

Thanks in advance 

Community Support
Community Support

Hi @Davidu ,


Dynamic Row Level Security is very suitable for your demands. Here's a sample for your reference.


This is my test table:



Click on Modeling Tab and navigate to Manage Roles icon.  Then define a role name and right-click on the required table. We are going to use USERPRINCIPALNAME() in the filter condition.


This function returns the name of the user as their email address.




Now we have completed the configuration in the desktop tool. We can test the roles in the desktop itself.


Under the Modeling tab, we have an icon called View as Roles. Click on that icon, we will get a new window.

We have to select both Other user and newly created Role. Then enter the email id of one user in the text box near to the Other user text.



User will only see the records related to himself.



If you share your reports on Power BI service, you should configure the RLS in


For detailed steps, please refer the blog:Dynamic Row Level Security (Dynamic RLS) - Microsoft Power BI Community


Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for the reply @v-yadongf-msft !

I have one issue like based on user context report is refreshing data in power bi desktop application. But, when i published in CRM, filter is not working. Can you help me on this please!

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors