Forum Discussion
RLS
Hi team, I got a question about RLS would like to ask for your kind advice, thank you. Originally we have setup 1 role called Cost_AM_M1&M2, this role means user could only see Cost, can't see Re...
Hi,
I'd wager the performance has nothing to do with your RLS. Can you post the dax you use for those roles?
In power bi desktop, you can test a role to see how it affects performance. Modeling > View as.
Hi, thanks for your reply.
Originally we used dynamic RLS in our PBI, but it impacted few dashboards' performance a lot. Then we converted to normal/dynamic RLS, just filter the related data from the selected tables. For example, I filtered Cost, AM, M1 from the corresponding tables for role: Cost_AM_M1.
