Allow report building on published datasets but not allow to change the data model
Today when we publish a dataset and let it be open for users to connect to and build reports on, they automatically gets access to change the datamodel in the published dataset. That means they can wipe out any Row Level Security we've applied to the dataset. This renders RLS only efficient for consumers of reports, and useless to maintain security/data limitations for report builders.
We need to be able to publish datasets for report builders where they can connect to them and build new reports/visualizations on them, but not let them alter the published datamodel.
The data set should be possible to publish as a "blackbox", users should be able to connect to them and on report level add and merge new datasources sharing any dimension in the published dataset, but they should not be able to alter the published dataset.
This is important for big dataset with many businesses and countries like us. Currently I have no way to promote Power BI use for our end users and one of the biggest reason is the inability for user to customize their own report. If granting edit right to user, we will expose to high risk of dataset or reports being deleted. Furthermore it will bypass the row level security and financial data will no longer keep confidential.