Forum Discussion
ShareDatasets between different workspace
Helenaoliveira Yes you would need to replicate the dataset in each workspace. The only way you can centralize a dataset would be to use Analysis Services. You would still need to deploy to each workspace, but any changes could be managed via the central model and deployment to the model would automatically make it's way downstream to all the datasets.
Helenaoliveira You would have to deploy the dataset to each workspace as you suggest.
In the workspace, you can have different types of members. Those that can only "read" and those that can edit. So if you need to have cross-department access but different levels of permissions you can set that on each App workspace. Based on your description, this should work.
Anonymous thanks for your response but if I create different workspace I will have the same datasets repeated in different workspaces. It makes sense has the same repeated in different workspace?
In my case, the datasets is the sales map with daily update, if I create different workspaces, I will have the datasets salesmap repeated with the respective update.
Helenaoliveira Yes you would need to replicate the dataset in each workspace. The only way you can centralize a dataset would be to use Analysis Services. You would still need to deploy to each workspace, but any changes could be managed via the central model and deployment to the model would automatically make it's way downstream to all the datasets.
Anonymous but it does not make sense to replicate the dataset in each workspace. If I replicate the dataset in several workspace and schedule daily refresh I will overload the system with these daily updates, right?
Helenaoliveira "It depends" - Are you talking about using imported datasets? How large are they, how long do they take to process? Or are you talking about the SSAS solution? In live connection, the dataset is just a passthrough, there is no data stored in the Service.