Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have been asked to create reports for 50+ account managers showing each the same visualizations except each will contain a filter with their own name showing only data related to them. Is there a way i can implement this without creating 50+ pbi reports and then manually creating new ones for new staff.
ideally would like to create just one report and as the user logs into pbi service only the report specific to them shows.
Solved! Go to Solution.
@akhaliq7 You want row level security (RLS). Here is a good link on Dynamic RLS: Dynamic Hierarchical Row Level Security - Microsoft Power BI Community
@akhaliq7 You want row level security (RLS). Here is a good link on Dynamic RLS: Dynamic Hierarchical Row Level Security - Microsoft Power BI Community
thanks for your help.