Forum Discussion

astano05's avatar
astano05
Icon for Helper III rankHelper III
1 year ago

RLS Not Passing Through Many to 1 Relationship

I am using RLS with UserPrincipalName from the systemuser table. It is not being passed to the opportunity table though. Any thoughts why? There is a Many to 1 relationship between opportunity and sales_team, but i have the cross filter direction set to both. When I try to Apply security in both directions I get the following error.

 

 

Error:

 

 

Need Help

3 Replies

  • Jai-Rathinavel's avatar
    Jai-Rathinavel
    Icon for Super User rankSuper User
    1 year ago

    astano05 Try disabling this toggle if enabled or vice versa 

     

     

    Did I answer your question? If yes, please mark my post as a solution.

     

    Thanks,

    Jai

  • ajohnso2's avatar
    ajohnso2
    Icon for Solution Supplier rankSolution Supplier
    1 year ago

    With a RLS table its not normally joined at all.

     

    Are you able to provide any sample data?

     

    Make your RLS a disconnected table and use the role definitions to filter the required tables.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.