Extending a BI Semantic Model with SQL Server Data Tools
BI Semantic Models developed with SQL Server Data Tools support all the features available in the PowerPivot Excel Add-in. The steps to add these features with SQL Server Data Tools are very similar to the steps already covered earlier in this chapter under the section titled “Extending a BI Semantic Model with PowerPivot.”
In addition, SQL Server Data Tools allows you to define security roles, a feature not available in the PowerPivot Excel add-in. The next sections describe the steps to add this functionality to a BI Semantic Model using the SQL Server Data Tools.
Creating Roles in SQL Server Data Tools
Roles provide the ability to limit access to Windows users by allowing specific rows that match the DAX . The permissions available include:
- None
- Read
- Read and Process
- Process
- Administrator
To create a new role in SQL Server Data Tools follow these steps:
Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.