Showing results for 
Search instead for 
Did you mean: 
New Member

How to filter data on basis of logged in user roles

Hi Experts,


We are going through one of the challange that, we have web application where we have called our power bi dasboard but we wanted to restrict the data on basis of logged in user's role from application.


How can we pass the session details to power bi service or logged in user's role to power bi and depdending on that we wanted to restrict the data or show which is in his/her scope.


Thank you in advance for advise and experties.

New Member

Thank you for your response but RSL and roles of my existing applications are not getting matched.
If user A has role 'Student' from existing application and associated "school" for student is "xyz" then I need to filter slicer or show only that perticular school in drop down and drill the results for specifc filter.

please note to view the report I need to plot into existing web application as we do with SSRS reports.


Please let me know if you confused with my questions and thank you in advance for your response.

Solution Sage
Solution Sage

Have you already read about row level security and USERPRINCIPALNAME()?

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn



Microsoft Employee

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!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors