RLS Not Passing Through Many to 1 Relationship

Hi astano05 ,

Did Jai-Rathinavel's reply help you?

If you want to learn more about applying a sucrity filter in both directions, please refer to

Solved: What does it mean to apply a security filter in bo... - Microsoft Fabric Community

Bidirectional cross-filtering in Power BI Desktop - Power BI | Microsoft Learn

And warmly reminder:

When creating cross filtering DAX formulas in Power BI Desktop, use UserPrincipalName. This field is often the same as a user's login, for example [email protected], instead of UserName. As such, you might need to create a related table that maps UserName or EmployeeID to UserPrincipalName.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.