Forum Discussion

AtchayaP's avatar
AtchayaP
Helper V
4 years ago
Solved

Powerbi

 i have given different email address to views as.

But I'm getting blank

  • AtchayaP  - Can you let me know the DAX formula you used for setting up the RLS?  Make sure you use the USERPRINCIPALNAME()  function.

    Did I answer your question? Mark my post as a solution!

    Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

6 Replies

  • gauthamboppana's avatar
    gauthamboppana
    Solution Specialist

    AtchayaP  - Can you let me know the DAX formula you used for setting up the RLS?  Make sure you use the USERPRINCIPALNAME()  function.

    Did I answer your question? Mark my post as a solution!

    Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

    • AtchayaP's avatar
      AtchayaP
      Helper V

      USERPRINCIPALNAME().

       

      This is my sample data, can you try with this data in powerbi, and can you send this file to me, so that I can clear it.I want to see datas on manager for example,  i want to set view as role for brad and I can see only data for  Brad employee(nasrin), same applies to everything.

      • gauthamboppana's avatar
        gauthamboppana
        Solution Specialist

        AtchayaP  - You need to set up the role for the managers as below. And, assign your manager emails to the rls role in the Power BI service. 





        Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

        Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

        Thank you very much !