Reference table in DAX keeping RLS Role on the table

[cleon]

Hi,

There is a way that when referencing a table in DAX, to which a role prefiltered by user name was applied. This maintains this prefilter ?, consulting directly the table if it returns records only of the logged in user.

My scenario is the following:
The table "fes_asistances_registers", referenced in a calculated table, is there a way to maintain the role prefilted defined in an RLS?

I would greatly appreciate your help!

[v-chuncz-msft · Accepted solution]

@cleon ,

You may achieve it by having the proper relationships configured.

https://docs.microsoft.com/en-us/power-bi/service-admin-rls#define-roles-and-rules-in-power-bi-deskt...