Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 | |
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 | |
5 | a@gmail.com |
5 | bb@gmail.com |
1 | a@gmail.com |
3 | bb@gmail.com |
The manager table is as below :-
id | |
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?
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.
I need urgent support on this. Can someone please help
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |