I have a Large "golden"dataset with tons of tables, columns and measures on which multiple thin Reports run. Now I have the bussinesscase that some employees want to use our data to Analyse in Excel. It would be ideal to let them connect to a dataset via Excel. However the big existing dataset is to complex for them so I want to offer them a simple dataset containing only the key tabels, columns and measures they would need but using the same datamodel and businesslogic as the "big golden dataset".
I was thinking of using the composite model feature for this where I create a new power bi file, Connect to the exisiting "golden" dataset and then setting it to Direct query. Then Simplify the model and publish it as a Self Service dataset.
I was wondering what your ideas where and if I am overlooking something with this option.