share dataset across different workspaces
There should be a way to share datasets across the different workspaces. This may be loaded to a global environment and related to capacity, it would use the capacity based on which workspace accesses it.
The benefit of this is to maintain some master datasets with calculations within them which can be joined to data from individual departmental data. Moreover this will eliminate the need of Analysis services and creating a refresh mechanism for it.
Yes, we should have privilege to share the dataset across the workspace.
Kevin H commented
Yeah, I have a large dataset with incremental refresh. The datasets, and their frequent refreshes, consume a lot of our Premium capacity. And because I have two different workspaces with different requirements, I have to publish a copy of this dataset in each workspace. It would be ideal if I could just publish and refresh the dataset in one place, but be able to access it from multiple workspaces.
Jeff Gilbertson commented
Workspaces should have two environments. One for QA/Staging, and another for Production. Only the admin can promote dashboards/reports to Production. The data sets do not change in Production until the admin has promoted the dashboard/report.