Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
@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
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.
@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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
19 | |
15 | |
13 | |
11 | |
9 |
User | Count |
---|---|
25 | |
22 | |
12 | |
11 | |
10 |