The Row Level Security of Calculation Groups in SSAS

[Anonymous]

I attempted to create the calculation groups in my SSAS model, There are some Row level security in my model already, And I'd like to know whether the Row level security can still work for the measures which using the Calculation Groups ? Since I noticed there is a limitation for the Calculation groups which is : Row level security (RLS) is not supported. Define RLS on tables in the same model, but not on calculation groups themselves (directly or indirectly). How to understand this limitation?

[V-lianl-msft]

Hi @Anonymous ,

As far as I know, writing a DAX query cannot bypass row level security.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for your confirmation. @V-lianl-msft 

[Greg_Deckler]

Sounds like any calculation group you create will not respect RLS (directly or indirectly)

[Anonymous]

Hi Greg, Thanks for your reply, Not yet to use the Calculation Groups in my Model,

I attempt to create the calculation groups in my SSAS model, There are some Row level security in my model already, And I'd like to know whether the Row level security can still work for the measures which using the Calculation Groups ?