Forum Discussion
Individual User login dashboard
Hi aditya1192
I got you, and I believe you need implement the dynamic RLS regarding to the UPN/username, below detailed blog for your reference:
https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
You can manage the UPN/usename in the table as above and every time user logged, they can only see the the data relates to his own UPN, also, it's able to add the whole group instead of type the name one by one under security. Note that keep the whole group as read-only member in the workspace.
Community SupportHi aditya1192
I think you're referring to the RLS, that people can only see the data within their scope and can't access to the other info. right?
But we always manage the roles in desktop and people are limited access in report , you can also pin the whole report to dashboard. below official document are for your reference:
https://docs.microsoft.com/en-us/power-bi/desktop-rls
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
v-diye-msft Thank you for the solution.
My issue is that lets say i have 1000 users data in a databse stored in a server. Now i will create a dashboard lets say a bar graph and a funnel chart. Now i want to create the visualization in such a way that when a user logs in to his or her account(any account as a matter of fact), i want the dashboard to fetch the user details form the server and only show his or her account details with visualization. Hope it makes sense.
Thanks.
- v-diye-msft
Hi aditya1192
I got you, and I believe you need implement the dynamic RLS regarding to the UPN/username, below detailed blog for your reference:
https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple
You can manage the UPN/usename in the table as above and every time user logged, they can only see the the data relates to his own UPN, also, it's able to add the whole group instead of type the name one by one under security. Note that keep the whole group as read-only member in the workspace.
