Tabular Security - White Paper

Microsoft recently published the second of two white papers that our veteran Analysis Services team member, Cathy Dumas, wrote on the tabular model. This one is called Securing the Tabular BI Semantic Model. You can download the samples for the whitepaper from https://securitytabularbi.codeplex.com/.

When I picked up the two white papers (this one and DirectQuery), I thought this one would be the easier of the two to understand and implement. After all, the basic concepts of the security model can be summarized in a blog post, and there’s even a tutorial on MSDN on how to implement dynamic security. Easy, right? Wrong!

Turns out, the examples were incredibly difficult to write as Cathy shares. Even though there is already an example for dynamic security, the LOOKUPVALUE() function used in the example to implement dynamic security does not perform very well. The dynamic security examples in the white paper use different mechanisms to implement the dynamic row filters. I won’t spoil the surprise, download the white paper and see for yourself.

There's a bit in there about security designs, when to use Kerberos, etc. Not included is how to configure Kerberos for use with Analysis Services. If you need to do that, check out blog posts for previous releases, such as this Kerberos configuration guide and this Kerberos configuration checklist. Also not included in the paper is a discussion of security and DirectQuery, go read the DirectQuery white paper if you need to learn about that.

Again, hope you like the paper.