Filter for Dashboard but not report

[justingraff88]

What I am trying to accomplish is publishing an employee schedule. I would like it so that on the dashboard it filters to the employee based on their username but then on the report they are able to see all other users data.

I think/hope I am close right now. I used RLS and userprincipalname() to filter the dashboard and it is showing how I want, however, it also filters the report. Is it possible to do different things for the report and the dashboard?

[v-frfei-msft · Accepted solution]

Hi @justingraff88,

Currently it is not possbile to achieve your goal. As RLS is applied to the dataset, as we know the relationship of dashboard,report and dataset. So we cannot apply the RLS seperatly. You can create two datasets to work around here.

Regards,

Frank

[justingraff88]

Thanks Frank. Using two datasources did work