Choosing role

[Milozebre]

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

[v-piga-msft · Accepted solution]

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]

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