Dataset Security

Hi bolashd,

Generally, there are two main parts of Power BI. They are Power BI Desktop and Power BI Service. (We won't talk about Mobile and Embedded here). 

Dataset only can be manipulated in Desktop. (Add calculated columns and measures.) Service is the powerful tool to share the work. We can create new reports with Service. But we can't change the dataset in Service. I think this suit the most needs.

So create a model with Desktop, then publish to Service. Power BI have several ways of sharing. I think the App workspace (preview) would be a good idea for your scenario. An app workspace contains all the things, including dashboards, reports, workbook, and dataset (can't be modified). We publish to the special audiences or the whole organization when we finish a prebuilt solution. We can add members who are going to customize the solution to the App and grant others read-only access. So one dashboard will be the prebuilt, users can built another one. Both the dashboard can share the same reports. Reference: powerbi-service-create-apps

A content-packs almost do the same thing of App workspace. If a user want to customize, the user have to make a copy.

I just post something most related to the scenario. There are more details. Please take these thing into consider: We can't manipulate dataset in the Service. If we want the user to customize the dataset, they also can change the whole dataset.

Best Regards!

Dale