Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello everyone,
I got into trouble when I applied RLS in my dashboard. I have 2 tables: Security_A, and Security_B (photo below).
The user's username in Security_A (user_ID_A) or Security_B(user_ID_B). When the user login the server, the dashboard automatically applies the RLS by username, I set the RLS in the PBI Desktop like the photo below. But it doesn't work. What should I do to fix that? Can anyone help me? Thanks
Solved! Go to Solution.
Hi,
When working with RLS, it could be a good practice to use the USERPRINCIPALNAME() native function. This function returns the current authenticated user that is viewing the report. Also, you can filter the dimensions directly in your facts table (Sale_Performance) by looking up the user name in your security table (In this way you dont need to create relashionship between your security and sales table).
In the manage roles popup you could filter 'Sale_Performance'[business_Sm] field like this:
[Business_Sm] = LOOKUPVALUE(
Security_A[Business_Sm],
Security_A[User_ID_A],
USERPRINCIPALNAME() -- User Authenticated email // If you can, you also can format this string to bring the value you want
)
Hope it helps
Hi,
When working with RLS, it could be a good practice to use the USERPRINCIPALNAME() native function. This function returns the current authenticated user that is viewing the report. Also, you can filter the dimensions directly in your facts table (Sale_Performance) by looking up the user name in your security table (In this way you dont need to create relashionship between your security and sales table).
In the manage roles popup you could filter 'Sale_Performance'[business_Sm] field like this:
[Business_Sm] = LOOKUPVALUE(
Security_A[Business_Sm],
Security_A[User_ID_A],
USERPRINCIPALNAME() -- User Authenticated email // If you can, you also can format this string to bring the value you want
)
Hope it helps
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
88 | |
83 | |
64 | |
49 |
User | Count |
---|---|
127 | |
108 | |
87 | |
70 | |
66 |