RLS on DirectQuery
Greetings everyone! I'm having trouble configuring the RLS for my report. I've searched several sources on youtube, but nothing has been able to help me. At first I have 2 tables: And I configured the RLS as shown in the image below: When I use EmailBP from BPs por Entidade table in a slicer, I can filter PEOPLE VW_FACT_INDI table normally. However, when I simulate the role in RLS, BPs por Entidade is filtered, but PEOPLE VW_FACT_INDI is not. Why is that? How can I solve this problem? Best Regards,
