Exporting schema while not leaking datasets

[ClaireTeoh]

Hi, 

I am trying to export or share the data model / schema from power bi, while not letting others to read the data. Meaning, they should be able to get the data model like tables and relationships, without any data in it. 

I tried to filter out the data, selecting nothing from the table, so export the data model. However, the data still can be recovered from the steps in the transformation power query window.

Is there any solutions, please advise.  

[amitchandak · Accepted solution]

@ClaireTeoh , Restrict the data and publish on service. And allow users to change the semantic model at the workspace level. they will able to see the model but can not update sources or steps 

[ClaireTeoh]

Hi Amitchandak, 

Thanks for providing the solution. 

Just a quick clarification, if my understanding is correct. 

Action from me:

set the sensitivity to "Read only" > publish to my workspace 

People connecting from my workspace:

can see the schema or data model, but not the datasets (because the table view, "transform data" or other modification features are disabled in the panels and tool bar)

This works perfectly from my end. 

However, if this was not what you were mentioning, please let me know, if there is another way to do so. 

Edited:

I managed to restrict the data. 
Modelling > Manage roles > perform restrictions on the data. 

Claire.