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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Unable to filter out based on the User logged

I have three tables device name, device details and User details, want to display device details in a slicer based on the user logged in. I have already set up RLS.

 

Could anyone help me on this?

 

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous , Hope device details is fact joined to the User and the user is having email or joined with the RLS table having email and RLS/User table is filtering the device details.

 

If join is bidirectional, security filter option should be checked

 

You need to have a role like

email = userprincipalname()

 

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here
Anonymous
Not applicable

Basically i have connected the user table and device facts table by the User ID. i have also created a measure and set up RLS. still do not see the devices getting filtered.

 

priyanka1895_1-1675877560301.png

 

 

priyanka1895_0-1675877526020.png

priyanka1895_2-1675877598396.png

priyanka1895_3-1675877641165.png

@amitchandak Thanks in advance!

Hi , @Anonymous 

According to your screenshot,you seem to have configured the corresponding RLS.

To test dynamic RLS on Desktop, you need to click "View Row" and select the role you configured, and check User and enter the corresponding username to test whether RLS is configured successfully.

vyueyunzhmsft_0-1675907290187.png

If this sitll dose not work , you need to check the relationship and the configuration for rls and model relationships, for more information, you can refer to :
Dynamic Row Level Security with Profiles and Users in Power BI : Many-to-Many Relationship - RADACAD

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Kudoed Authors