Implementing security in Tabular Models
One of the key differentiators or reasons to move Power Pivot models into SQL Server Analysis Services is security. Tabular Models support a much more robust security model than what is available in Power Pivot in Excel or SharePoint.
Getting ready
In order to work with security, you will need some users that you can assign to the roles. In my solution, I have added SteveReader and SteveFiltered to my local computer. Normally, you would be using Active Directory users and groups to manage your security. If you have a test or development environment with users at your disposal, use them. In either case, you will need users to complete this next recipe.
How to do it…
You can open the Role Manager dialog by clicking on the Roles button on the toolbar or the Roles option in the MODEL menu item. This will open the Role Manager dialog. You will be creating a read-only role, which will prevent a user from reloading data or making changes to the model...
