Setting dataset permissions for contributors (report writers)
As we all know, the implemented RLS on a dataset kicks in only for users who access the report via a shared link, have read-only direct access to the report, or have a Viewer role on the workspace. The report writers should have Build permission on the referenced dataset(s) to connect to the datasets in Power BI Desktop to create thin reports. A thin report is a report we build upon an existing dataset. In other words, thin reports do not have data models but a data visualization only. Follow these steps to grant Build permission to contributors after navigating to a desired workspace:
- Hover over the first chain dataset and click the more options ellipsis button.
- Click the Manage permissions option.
- Hover over a user account or security group and click the More options ellipsis button.
- Click Add build.
The following image shows the preceding steps:
Figure 14.21: Grant build...