Forum Discussion

Milozebre's avatar
Milozebre
Helper V
8 years ago
Solved

Choosing role

Good morning community, 

 

I have a question about role.

I have two roles that work very well for a report that manage working times. A role for users who see their time encoded. And another for managers who check times and ask for corrections. Roles are based on the UPN. But a manager also encodes time and have a manager. Is there a way for a manager to decide which role to use, also via office 365. Thank you

 

  • Hi Milozebre,

     

    It seems that you're using RLS for Power BI report.

     

    If I understand your sceanrio correctly that your manager want to both see their time encoded and have a manage?

     

    You may could set the manage user to more than one role, and the user then will have a consolidated view of both roles. For example, a user with both roles for the USA and Europe sales manager will see data from All Europe and USA.

     

    For reference, you could have a look at this blog.

     

    Best Regards,

    Cherry

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar

    Hi Milozebre,

     

    It seems that you're using RLS for Power BI report.

     

    If I understand your sceanrio correctly that your manager want to both see their time encoded and have a manage?

     

    You may could set the manage user to more than one role, and the user then will have a consolidated view of both roles. For example, a user with both roles for the USA and Europe sales manager will see data from All Europe and USA.

     

    For reference, you could have a look at this blog.

     

    Best Regards,

    Cherry

    • Milozebre's avatar
      Milozebre
      Helper V

      Hello cherry, 

       

      Your solution is working but the user can see the entire report and no only the page user. 

       

      I will continue to investigate. 

       

      Thank you very much for your help.

       

      Dimitri