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 :-
The tester table is as below :-
The manager table is as below :-
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 :-
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?
