Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.