Forum Discussion
Helper IIIRLS 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:
3 Replies
- Jai-Rathinavel
Super User
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
ajohnso2Solution Supplier
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.
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.
