Forum Discussion
RLS Help
No problem. No, you need the RLS to still be applied to the detail table so they only see their own items, the bridge table will allow both tables (one with RLS and one without) to be filtered. In the bar chart visual you will utilize the field from the bridge table instead of your unrestricted table.
Hi - thank you very much - that has worked perfectly
Thank you for replying - the data model is very simple - 1 lookup table sorting the due date status and the 2 identical fact tables - would I apply the RLS to to the bridge table?
No problem. No, you need the RLS to still be applied to the detail table so they only see their own items, the bridge table will allow both tables (one with RLS and one without) to be filtered. In the bar chart visual you will utilize the field from the bridge table instead of your unrestricted table.
Hi - thank you very much - that has worked perfectly
You're very welcome!