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: 

Join the FabCon + SQLCon recap series. Up next: Power BI, Real-Time Intelligence, IQ and AI, and Data Factory take center stage. All sessions are available on-demand after the live show. Register now

Reply
rajasekar_o
Helper V
Helper V

RLS PROBLEM Access.

‎06-05-2024 05:42 AM

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

super user result not showing

rajasekar_o_0-1717590966793.png
help me team how to solve this 

 

Message 1 of 5
472 Views
0
4 REPLIES 4
AllisonKennedy
Community Champion
Community Champion

‎06-17-2024 06:26 PM

@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. 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Message 5 of 5
396 Views
0
rajasekar_o
Helper V
Helper V

‎06-05-2024 10:46 PM

@AllisonKennedy 

rajasekar_o_0-1717652600319.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 4 of 5
427 Views
0
AllisonKennedy
Community Champion
Community Champion

‎06-05-2024 01:08 PM

@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?


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Message 2 of 5
439 Views
rajasekar_o
Helper V
Helper V
In response to AllisonKennedy

‎06-06-2024 10:34 AM

@AllisonKennedy 

rajasekar_o_0-1717695280290.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 3 of 5
421 Views
0

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

FabCon and SQLCon Highlights Carousel

FabCon &SQLCon Highlights

Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.

View All