We are having problems with Scheduled reports. We have security filters set for Managers & Users Using this expression: OR(IN(USEREMAIL(), Managers[Manager]), USEREMAIL() = [Owner]) - Managers have full access to all data but the users are restricted to their own data - works fine.
We setup slices restricting the table values to particular Locations (Eg. Slice Name: Seattle will only allow the values [Location] = “Seattle”) - This works fine.
We used the slice named Seattle to create a schedule report (Seattle Report). One of our managers created the report (who has full access to all data). The report should only have values that belonging to Location Seattle HOWEVER this report has the entire data table with all other Locations as well. Effectively, the slice Seattle is not functioning in schedule reports.
Can any one shed some light on this please?