O'Reilly logo

Microsoft Tabular Modeling Cookbook by Paul te Braak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing dynamic security

Implementing security through roles that contain hardcoded row filters is a very convenient way to manage data access to the model. It's also relatively easy to understand.

However, some downsides of that method are that the roles require creation and maintenance. Imagine a situation where hundreds or thousands of detailed roles have to be created; this would require a lot of work! Further, while the use of Active Directory groups is convenient from a model's administration perspective, it removes a large amount of control from the BI environment (and the BI department). Often, this is not desirable (especially in smaller departments and agile environments) as the BI team is solely responsible for administering security. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required