Forum Discussion
Row level security with user email
Hi iversa,
Yes, I also think dynamic RLS will suitable for your scenario, you can create a role based on username to filter.(you need user table to mapping current user emails and related to other tables to enable filter effect)
After finish setting dynamic role, you can publish your report and assign role to users by security setting(power bi services side) .
Row-level security (RLS) with Power BI
Reference link:
Regards,
Xiaoxin Sheng
Hi iversa,
Yes, I also think dynamic RLS will suitable for your scenario, you can create a role based on username to filter.(you need user table to mapping current user emails and related to other tables to enable filter effect)
After finish setting dynamic role, you can publish your report and assign role to users by security setting(power bi services side) .
Row-level security (RLS) with Power BI
Reference link:
Regards,
Xiaoxin Sheng
What if we have 300 employees in our organization and we want to make each person only see his own result?
Should we assign 300 employees to the RLS we defined!!?
In addition, poeple join and leave the company. So, we cannot always do that manually!
What is the easiest/automatic way to assign people to the RLS filters?