Power Pivot limiting filter options but still allowing filtering

Copper Contributor



I have loaded some data into power pivot that I am using in reports going to different cost centres owners. I have filtered on the cost centres needed for each report but I want to stop the cost centre owners from being able to select cost centres that aren't theirs, though still be able to use the cost centre field to filter on their own cost centres and move that around as they see fit. Is it possible? How can I do it?

2 Replies



How about Row-Level Security (RLS)?

@Kidd_Ip thanks, how do I implement it?