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.
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.
Anonymous I have a similar problem.
We are trying to connect to datamarts and create a centralized dataset that can be used by various workspaces. How can we do that?
you mentioned we need to take the centralized dataset and replicate that dataset in all the workspaces (if different workspaces are planning to use the centralized dataset). These workspaces will use a subset of the centralized dataset.
Q. Are the subset datasets simply pointers to the centralized dataset or are the replicated copies of the entire dataset.
Q, Can the individual datasets (the datasets used in different workspaces) be locked down as per the permissions?Anonymous Keep in mind that post was over a year ago. I have much better advice now :) In the public roadmap there is a new feature called "Shared and Certified Datasets" - this would be the solution you are looking for. I would potentially wait for a bit to see if this drops soon. Documentation of the future feature can be found here -> https://docs.microsoft.com/en-us/business-applications-release-notes/April19/business-intelligence/power-bi-service/shared-certified-datasets
public roadmap here -> https://powerbi.microsoft.com/en-us/roadmap/