Forum Discussion
Undo (dynamic) row level security with a DAX filter?
Hi, At the moment I am having the following challenge. I hope someone can help me. I would like to create a report, and embed it in the portal. I am planning to use (dynamic) role level secur...
As my screenshot shows. You can obtain the behaviour you want by setting your RLS on a table not connected to your model. This table is used as a filter in your report and you synchronize this filter with another (hidden in view) filter that uses the column that actually transfers filters down to your fact table. In essence, you have RLS on what users can select, but not on what underlaying data is available for your measures. The only problem with this method is that you should disable analyze in excel mode, otherwise the IT savy users may bypass your RLS setup.