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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
nirajsevalkar51
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.

2 REPLIES 2
nirajsevalkar51
New Member

Thank you for your response but RSL and roles of my existing applications are not getting matched.
Ex.
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.

ppm1
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

 

Pat

Microsoft Employee

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors