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.
Hello,
I need help to figure how see all info in my database for the users listed as "administrador".
The problem is that "Administrador" are not an option in the fact table.
i try the following DAX code to create the Dynamic RLS but it doesn't work (the original file is in the link below)
https://github.com/MathiasChaparroItau/PBI-Files
[VISION] =
VAR _userp = USERPRINCIPALNAME()
VAR _vision =
CALCULATE(
MAX( 'RLS'[VISTA] ),
FILTER( 'RLS',
'RLS'[CORREO] = _userp )
)
RETURN
IF( _vision = "ADMINISTRADOR",
true(), _vision )
Part of the Fact Table
FECHA | DESCRIPCION | TIPO | VISION | IMPORTE |
31/10/2021 | GASTOS ADMINISTRATIVOS | FIJO | MARKETING | 220 |
31/10/2021 | EGRESOS EXTAORDINARIOS | FIJO | GERENTES | 243 |
31/10/2021 | EGRESOS EXTAORDINARIOS | PROYECTO | CUENTA NUEVA | 154 |
31/10/2021 | GASTOS ADMINISTRATIVOS | FIJO | 56 | |
31/10/2021 | GASTOS ADMINISTRATIVOS | FIJO | MARKETING | 131 |
Table RLS
RESPONSABLE | VISTA | ID Perfil | CORREO |
Mathias Chaparro | ADMINISTRADOR | 1 | |
Jose Benegas | ADMINISTRADOR | 1 | jose.benegas@mail.com.py |
Sylvana Areco | ADMINISTRADOR | 1 | Sylvana.areco@mail.com.py |
Adriana Lopez | MARKETING | 2 | |
Alfredo Prono | MARKETING | 2 | Alfredo.prono@mail.com.py |
Andres Cubas | GERENTES | 3 | |
Andrea Heleno | GERENTES | 3 | Andrea.heleno@mail.com.py |
Jose Cardenas | GERENTES | 3 | Jose.cardenas@mail.com.py |
Alejandro Gonzalez | CUENTA NUEVA | 4 | Alejandro.gonzalez@mail.com.py |
Catalina Areco | CUENTA NUEVA | 4 | Catalina.areco@mail.com.py |
I would appreciate your help with this problem. I thank you in advance!
I changed the code a little to return true or false but I still can't get the "ADMINISTRADOR" to see all the rows.
Could someone help me please? I am not an expert and I would like to know if someone could help me
VAR _Admin =
IF( MAX('RLS'[VISTA]) ="ADMINISTRADOR",
1,
0
)
RETURN
IF (
MAXX (
FILTER ( 'RLS', 'RLS'[CORREO] = USERPRINCIPALNAME() ),
_Admin )= 0,
MAX('RLS'[CORREO]) = USERPRINCIPALNAME(),
true
)
Could someone guide me?
The RLS works with all the "VISTAS" except those of "ADMINISTRADOR" which are not found in the fact table
tks
the RLS rules need to return true or false, not strings.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
121 | |
79 | |
47 | |
45 | |
36 |
User | Count |
---|---|
179 | |
89 | |
69 | |
47 | |
47 |