Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server - Windows only
Azure SQL Managed Instance
In Master Data Services, assign permissions to model objects when you need to give a user or group access to data in the Explorer functional area of Master Data Manager, or when you need to make a user or group an administrator.
Note
When you assign permission to a model, permission to all other models is implicitly denied. If you do not assign model object permissions, the user or group cannot access any data in Explorer.
To perform this procedure:
You must have permission to access the Users and Group Permissions functional area.
You must be a model administrator. For more information, see Administrators (Master Data Services).
In Master Data Manager, click User and Group Permissions.
On the Users or Groups page, select the row for the user or group that you want to edit.
Click Edit selected user.
Click the Models tab.
Optionally, select a model from the Model list.
Click Edit.
Expand the tree, and click the model object you want to assign permissions to.
From the menu, select a combination of Read, Create, Update and Delete, or Deny.
On the top model level, select Admin if you need to make a user model administrator.
Click Save.
Delete Model Object Permissions (Master Data Services)
Model Object Permissions (Master Data Services)
Create a Model Administrator (Master Data Services)
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Aplicación de la seguridad de modelos de Power BI - Training
Aplique la seguridad de modelos en Power BI mediante la seguridad de nivel de fila y la seguridad de nivel de objeto.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demostrar métodos y procedimientos recomendados que se alinean con los requisitos empresariales y técnicos para modelar, visualizar y analizar datos con Microsoft Power BI.
Documentation
Permisos del área funcional - SQL Server Master Data Services
Permisos del área funcional (Master Data Services)
Seguridad - SQL Server Master Data Services
Obtenga información sobre la seguridad en Master Data Services, incluidos los tipos de usuarios, cómo establecer la seguridad, la seguridad en el complemento para Excel y las tareas relacionadas.
Administradores - SQL Server Master Data Services
Obtenga información sobre los tipos de administradores de Master Data Services: administradores de modelos, administradores de entidades y superusuario.