Row Level Security and Top N don't play nice together

[xxcorpxx]

When a user with specific row level security consumes a report with Top N, it doesn't show HIS/HER specific Top N.  This person might not have access to those Top N's and the report will be blank or only show a few items.  

So, if you look at a top 20 report at a limited roll, you may only see 5 items instead of your specific top 20.  It's worse when you slice by month - "Items" drop off because they may not be top N.  NOT good, basically negates using Top N for anyone with RLS at least from SSAS Tabular. Not sure if it effects everyone.

Also, Top N needs to work at multiple levels in a table or chart.

[Anonymous]

@xxcorpxx,

Could you please share sample data of your  table and post expected result here?

Regards,
Lydia Zhang

[xxcorpxx · Accepted solution]

I might have to take this back- I realized that i had a another filter set to show only items above 0.

It gets really tricky when you have stuff filtered.  Hard to see what is in the list at a quick glance.

I think you should highlight filtered items in yellow so there is no questions at a quick glance.