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
Enforce Power BI model security - Training
Enforce model security in Power BI using row-level security and object-level security.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.