I have a similar use case except the data is not sensitive so I do not want to use Row Level Security.
Mine is a sales report, where each branch manager will need their own pre-filtered dashboard. Branch managers report to Region Managers, who need their own version.
Probably looking at about 175 dashboards!! Not ideal!!
I don't want to use RLS as a workaround because it's not the right solution for this use case.
Is there another option?
Any help would be very much appreciated!!