Skip to main content
IMPLEMENTED

Ability to apply the PowerBI setting "Apply security filter in both directions"

Related products:TimeXtender Data Integration
  • November 10, 2023
  • 6 replies
  • 45 views

When using Row Level Security with an Analysis Services semantic model, it is necessary to have the ability to set the flag 'Apply security filter in both directions' in a manner similar to how you can set the 'Filter Direction' in table relations.

Currently, this functionality is not available, which results in Row Level Security (RLS) not being applied to all dimensions within the model.

For instance:

In a model that includes two dimension tables containing sensitive data and one fact table; when RLS is applied to one of the dimension tables, it does not filter the second dimension table.

6 replies

erik.van.mastrigt
TimeXtender Xpert
Forum|alt.badge.img+3

Hi @JonasZ ,

I have customers in the need for this too. The feature request is posted before, but not implemented yet.

https://support.timextender.com/ideas/ssas%2Dtabular%2Dsecurity%2Dfilter%2Drls%2Don%2Dbi%2Ddirectional%2Dfilters%2D333

 


  • Author
  • Starter
  • November 10, 2023

Alright, I missed this. Had a support case with TX about this and they closed the case with saying “Please submit a product idea here: ...”

I feel that I would not be able to use RLS on any of my customers without this setting.

Maybe it needs to be bumped!


erik.van.mastrigt
TimeXtender Xpert
Forum|alt.badge.img+3

We currently use Tabular Editor to enable this security filtering. After deployment of the model with TX, we modify it with this tool to apply the missing TX-features.

Tabular Editor version 2 can be used for free.

https://github.com/TabularEditor/TabularEditor

 


  • Author
  • Starter
  • November 10, 2023

Thanks! How is this affected then you deploy the model from TX? Do you need to change this every time?


erik.van.mastrigt
TimeXtender Xpert
Forum|alt.badge.img+3

Unfortunately yes, you have to change it after each deploy


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5
SUBMITTEDIMPLEMENTED