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	a@gmail.com
2	a@gmail.com
3	a@gmail.com
1	b@gmail.com
3	b@gmail.com

The tester table is as below :-

id	email
5	a@gmail.com
5	bb@gmail.com
1	a@gmail.com
3	bb@gmail.com

The manager table is as below :-

id	email
4	a@gmail.com
1	a@gmail.com
1	ccc@gmail.com

We can see that a@gmail.com has all the 3 roles available with the id showing which rows a@gmail.com is allowed to view of all the rows in the data table.

If the user (a@gmail.com) 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 (a@gmail.com) 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