SSAS Tabular Model-Security-Part-3-Adnvance Dynamic Security

This video is the last video of this series. This video is about how to implement Advance Dynamic Data Security in Tabular model.
The main benefit of this approach is performance. You’ll see how to design a model in such a way that your security implementation will always perform same irrespective to number of dimension columns on which you have implemented security.
Videos in this series-
1. SSAS Tabular Model-Security-Part-3-Role Based Security- • SSAS Tabular Model-Sec...
2. SSAS Tabular Model-Security-Part-3-Dynamic Security- • SSAS Tabular Model-Sec...
3. SSAS Tabular Model-Security-Part-3-Advance Dynamic Security- • SSAS Tabular Model-Sec...
You suggestion and comments are most welcome. If you have any question, please let me know in the comment section.
Please subscribe :)

[@evett16]

Great videos!!! Could you please teach us how to apply the row level security to some columns? Thank you very much for the 3 videos! They are really great!

[@syedkaleem9031]

Hi Vinod, Great article. My question is about how to implement dynamic row-level security for a database schema that has multiple fact tables?

[@syedkaleem9031]

Good article. However, when I tried to implement dynamic role level security, I could not do it. When I try to Evaluate vw_dimUserPermissions, I get two rows instead of only one row assigned to the user Jeff Bravo. What else am I doing wrong here?

[@rickmemmer5625]

Great work once again -- really enjoying your videos!

[@knowbitools1241]

Quite informative video

[@balachandarmoorthy4414]

How can we apply security to only specific measures? Say if I have 5 measures in my cube and users can see 3 measures unrestricted but will have restricted access for the other 2 measures

[@dmytroandriychenko4714]

Thank you for the videos, really clear and detailed - great work! May I ask why you use CONTAINS() function in the Part2 and CALCULATE(COUNTROWS...) in this advanced part? CONTAINS appears to be more intuitive and valid for both implementations?

[@ryanwade865]

Great video! Very informative! Can you get rid of the calculate statement in the DimSecurity table if you are using the bi-directional join in SQL 2016?

[@RoshanJhamca]

Really nice videos ..can you please provide me some solution on column level security in tabular model

[@gpnaidu7813]

can we hide the base model from the user and can they only see the perspective?

[@RajanieshKaushikk]

I tried to implement the security but it is nor working