Table selection from central dataset in other workspace

Hey DataBas ,

you can provide Object Level Security (OLS) to tables in the central dataset (https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-ols?tabs=table)

Then you can provide build permission on the dataset to the contributors. Build permission allows users to create their own reports, also adding measures. Build permission allows users to connect to Power BI dataset from within Power BI desktop, and then publish the report to a second dataset. Data will not be copied, the new report contains a link to the central dataset.

A data refresh of the central dataset will be immediately reflected in the new dataset.

This capability is called shared dataset: https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-permissions

I'm always hesitant to provide all the permissions to users, most of the time build permission is absolutely sufficient:

OLS requires that the contributors are not part of the workspace that holds the central dataset, of course this is also valid ofr Row Level Security (RLS). I tend to separate the data (datasets) from the content (data visualizations) by using two workspaces. This allows to apply security like RLS and OLS but being able to provide report creators the possibility to create their own reports.

Regards,

Tom