Shared dataset permissions

Hi, CrazyHorse66 

Here are some suggestions:

• 1. Create a new workspace specifically for the SMEs who need access to the underlying data. This will allow you to control access to the workspace and the datasets within it separately from the BI REPORT HUB workspace.
• 2. Add the AD group you mentioned to the workspace with the appropriate permissions. You may want to consider using the "Member" role for these users, which allows them to view and edit content within the workspace but does not give them full administrative privileges.
• 3. Within the workspace, create a separate dataset for each SME. This will allow them to work with their specific data for analysis without seeing other datasets they do not need access to.
• 4. When publishing reports, make sure to use the appropriate dataset for each report. This will ensure that the SMEs can only access the data they need for their specific reports.
• 5. In the Admin Portal, you may want to consider enabling the "Export Data" setting for the AD group. This will allow them to export data from the datasets they have access to, but not from other datasets in the workspace.

Dataset permissions - Power BI | Microsoft Learn

Build permission for shared datasets - Power BI | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.