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
MFelix's avatar
MFelix
Super User
4 years ago

Hi verri87 

 

You shoul not use on the RLS "USERPRINCIPALNAME" this is a text and not the function try to replace it by USERPRINCIPALNAME()

 

  • 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... 

    • MFelix's avatar
      MFelix
      Super User
      4 years ago

      Hi verri87 ,

       

      What do you mean by the report was empty when you created the role in the service?