Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
rajasekar_o
Helper V
Helper V

RLS 3 Level

‎06-05-2024 10:50 PM

hi team ,
i need a help,for RLS
I set BM wise , RM wise and Super user wise
BM-wise and RM-wise RLS are working properly, but for the super user, the values are not showing
following tables are am using

Cluster table

ARDCLUSTERBMEMAILRMRMMAIL
ARD1CBEBM001tom@gmail.comRM002ramkumar@gmail.com
ARD2CBEBM001tom@gmail.comRM002ramkumar@gmail.com
ARD3CBEBM001tom@gmail.comRM002ramkumar@gmail.com
ARD4CBEBM001tom@gmail.comRM002ramkumar@gmail.com
ARD5CBEBM001tom@gmail.comRM002ramkumar@gmail.com
ARD6MASBM002ram@gmail.comRM001gru@gmail.com
ARD7MASBM002ram@gmail.comRM001gru@gmail.com
ARD8MASBM002ram@gmail.comRM001gru@gmail.com
ARD9MASBM002ram@gmail.comRM001gru@gmail.com
ARD10MASBM002ram@gmail.comRM001gru@gmail.com
ARD11MDUBM003karthick@gmail.comRM002ramkumar@gmail.com
ARD12MDUBM003karthick@gmail.comRM002ramkumar@gmail.com
ARD13MDUBM003karthick@gmail.comRM002ramkumar@gmail.com
ARD14MDUBM003karthick@gmail.comRM002ramkumar@gmail.com
ARD15MDUBM003karthick@gmail.comRM002ramkumar@gmail.com
ARD16SABM004suriya@gmail.comRM001gru@gmail.com
ARD17SABM004suriya@gmail.comRM001gru@gmail.com
ARD18SABM004suriya@gmail.comRM001gru@gmail.com
      

Super user

EMAILNAMECLUSTER
vinoth@gmail.comvinothMAS
vinoth@gmail.comvinothCBE
vinoth@gmail.comvinothMDU
vinoth@gmail.comvinothSA
vani@gmail.omVANISA
vani@gmail.omVANICBE
vani@gmail.omVANIMDU

Sales

ARDSALESDATEINV NO
ARD1500001-01-2024INV001
ARD230001-01-2024INV002
ARD3350001-01-2024INV003
ARD4584401-01-2024INV004
ARD5800001-01-2024INV005
ARD6584701-01-2024INV006
ARD7354301-01-2024INV007
ARD84646501-01-2024INV008
ARD9454301-01-2024INV009
ARD106401-01-2024INV010
ARD11676701-01-2024INV011
ARD124564501-01-2024INV012
ARD1376801-01-2024INV013
ARD14465701-01-2024INV014
ARD15467401-01-2024INV015
ARD1646701-01-2024INV016
ARD176901-01-2024INV017
ARD1846701-01-2024INV018
ARD1654401-02-2024INV019
ARD2435424501-02-2024INV020
ARD34601-02-2024INV021
ARD443535401-02-2024INV022
ARD534601-02-2024INV023
ARD65601-02-2024INV024
ARD735601-02-2024INV025
ARD835601-02-2024INV026
ARD935601-02-2024INV027
ARD1078501-02-2024INV028
ARD1185701-02-2024INV029
ARD126301-02-2024INV030
ARD135401-02-2024INV031
ARD145201-02-2024INV032
ARD155401-02-2024INV033
ARD1645701-02-2024INV034
ARD17457301-02-2024INV035
ARD1835601-02-2024INV036


Relationships :

rajasekar_o_2-1717652960289.png

 

sales and cluster is related with many to one relation
cluster and superuser related with many to many relation 
RLS DAX :

BM:'CLUSTER'[EMAIL]=USERPRINCIPALNAME()
RM:'CLUSTER'[RMMAIL]=USERPRINCIPALNAME()
SUPER USER:'SUPER USER'[EMP ID]=USERPRINCIPALNAME()




super user result not showing

rajasekar_o_0-1717652887241.png

 

 

 

 

sales and cluster is related with many to one relation
cluster and superuser related with many to many relation 
RLS DAX :

BM:'CLUSTER'[EMAIL]=USERPRINCIPALNAME()
RM:'CLUSTER'[RMMAIL]=USERPRINCIPALNAME()
SUPER USER:'SUPER USER'[EMP ID]=USERPRINCIPALNAME()




Message 1 of 2
200 Views
0
1 REPLY 1
Anonymous
Not applicable

‎06-06-2024 11:32 PM

Hi @rajasekar_o ,
Based on your description and the data provided, I observe that your dax expression references the [EMP ID] field, which may not work for the RLS relationship you are using. You can try using Super User[Email] to restrict it.

Best regards,
Albert He

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

Message 2 of 2
164 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All