Forum Discussion

verri87's avatar
verri87
Regular Visitor
4 years ago

Send a report by email PDF to different users filter RLS

Hi    I have created a report over salary information to the employee and need to send this report monthly to the employee by email as a pdf. Problem is that i need the PDF to show only data that i...
Need Help
Show and Tell
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi verri87 ,

Additionally, the box Apply security filter in both directions should be checked.

As per document "By default, row-level security filtering uses single-directional filters, whether the relationships are set to single direction or bi-directional. You can manually enable bi-directional cross-filtering with row-level security by selecting the relationship and checking the Apply security filter in both directions checkbox. Select this option when you've also implemented dynamic row-level security at the server level, where row-level security is based on username or login ID."

Reference: Row-level security (RLS) with Power BI - Power BI | Microsoft Docs

 

Best Regards,
Community Support Team _ kalyj

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

  • verri87's avatar
    verri87
    Regular Visitor
    4 years ago

    Thanks for the answer. I dont have the access to apply security filter at the server level, så i will check with the admins on that. I also tried to create the role with the email = USERPRINCIPALNAME() but nothing happend. In the power bi service the report was emty when i created the role...