Forum Discussion
Row Level Security Only on Drillthrough
I have a single dataset that populates a bar chart based on groups. That bar chart then drills through to a details page to see each individual record.
How can I set up RLS so it limits only the drill through page to allow users to only see their groups but still see all groups on the main bar chart?
Will I need to create duplicate datasets and apply the RLS logic on the drillthrough dataset only?
My solution:
1) Import original dataset, call it XXX
2) In modeling tab, create a new table and set it equal to my original dataset, call it XXX_Secure. (XXX_Secure = XXX)
3) Create a relationship between XXX and XXX_Secure on group name.
4) Configure Row Level Security on the USERPRINCIPALNAME on table Y.
5) Create relationship from table Y to XXX_Security on the group name.
6) Create bar chart off of XXX
7) Create drill through detail page, include all fields you need from XXX
😎 Also add the group name from XXX_Secure to the detail page and minimize the column so it can't be seen.
This will allow all users to see all the data in the bar chart regardless of group name. Every bar in the chart will have a drill through option, but clicking on them will return empty details except for the groups the person viewing the report has access to.
10 Replies
TCavins This is amazing stuff. Thanks mate for the above info.
all i did additionally is just played with relationships (changed bi directional to Single) a bit and its all done.
So the bottom line is- In Main page, you can expose everything however, drillthrough page wil be Row Leveled access.
