Forum Discussion

rajasekar_o's avatar
rajasekar_o
Helper V
2 years ago

RLS PROBLEM Access.

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
ARD1CBEBM001[email protected]RM002[email protected]
ARD2CBEBM001[email protected]RM002[email protected]
ARD3CBEBM001[email protected]RM002[email protected]
ARD4CBEBM001[email protected]RM002[email protected]
ARD5CBEBM001[email protected]RM002[email protected]
ARD6MASBM002[email protected]RM001[email protected]
ARD7MASBM002[email protected]RM001[email protected]
ARD8MASBM002[email protected]RM001[email protected]
ARD9MASBM002[email protected]RM001[email protected]
ARD10MASBM002[email protected]RM001[email protected]
ARD11MDUBM003[email protected]RM002[email protected]
ARD12MDUBM003[email protected]RM002[email protected]
ARD13MDUBM003[email protected]RM002[email protected]
ARD14MDUBM003[email protected]RM002[email protected]
ARD15MDUBM003[email protected]RM002[email protected]
ARD16SABM004[email protected]RM001[email protected]
ARD17SABM004[email protected]RM001[email protected]
ARD18SABM004[email protected]RM001[email protected]
      

Super user

EMAILNAMECLUSTER
[email protected]vinothMAS
[email protected]vinothCBE
[email protected]vinothMDU
[email protected]vinothSA
[email protected]VANISA
[email protected]VANICBE
[email protected]VANIMDU

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

super user result not showing


help me team how to solve this 

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

4 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    2 years ago

    rajasekar_o  - what does your data model ( relationships ) view look like? 

     

    Are you using the RLS with different roles? What DAX or how have you created the roles if so?

    • rajasekar_o's avatar
      rajasekar_o
      Helper V
      2 years ago

      @AllisonKennedy 

       

      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()
  • rajasekar_o's avatar
    rajasekar_o
    Helper V
    2 years ago

    AllisonKennedy 

    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()



  • AllisonKennedy's avatar
    AllisonKennedy
    Community Champion
    2 years ago

    rajasekar_o  Thanks for the relationship view - that's helpful. Next piece of info we need is what is the actual DAX you have in the RLS roles you've set up? The Super User role should be straightforward, just need to add the filter on the SuperUser table and no filter on the cluster table.