Same User Views Report with multiple Roles

[mohit_K]

I have to create a power bi report such that the same user can access it using multiple roles
The data table is as shown below :-

id	engineer	tester	manager
1	10	20	15
1	20	30	10
2	15	10	20
3	20	10	30
4	10	10	25
5	30	20	35
1	40	30	30
2	15	30	10
4	50	30	15
4	5	45	20

The engineer table is as below :-

id	email
1	[email protected]
2	[email protected]
3	[email protected]
1	[email protected]
3	[email protected]

The tester table is as below :-

id	email
5	[email protected]
5	[email protected]
1	[email protected]
3	[email protected]

The manager table is as below :-

id	email
4	[email protected]
1	[email protected]
1	[email protected]

We can see that [email protected] has all the 3 roles available with the id showing which rows [email protected] is allowed to view of all the rows in the data table.

If the user ([email protected]) views the report as engineer they are able to see something like :-

id	engineer
1	10
1	20
2	15
3	20
1	40
2	15

If the user ([email protected]) views the report as tester they are able to see something like :-

id	tester
1	20
1	30
5	20
1	30

So is it possible to filter out the content of the report based on what the same user wants to view?

Can we achieve this dynamic filtering of rows and columns based on what the user wants to view using Row Level Security or 

URL based filtering or any other approach?

[Anonymous]

Hi @mohit_K ,

I have already replied to your original post. Is your test result unsuccessful? If it fails, can you describe the problem in detail?

Best Regards,

Stephen Tao

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

[mohit_K]

@v-chuncz-msft  Can you please help me on this urgently

[mohit_K]

@v-jingzhang Can you please help me on this urgently

[mohit_K]

I need urgent support on this. Can someone please help