cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kin Frequent Visitor
Frequent Visitor

Datasets in Workspace

We are trying to connect datamarts to Power BI and create a centralized dataset that can then be used by various workspaces. How can we do that?
The problem that we are trying to solve is:
- We want to use the centralized dataset that can be used by different workspaces which will, in turn, be accessed by different departments in the company (e.g. IT, HR, Accounts)
- The members in each workspace should only be able to view the datasets that they should have access to (e.g. IT should not be able to view the datasets for the HR even though all the info is in the centralized dataset)

I read on the other channel that I can connect via Analysis services to create a centralized dataset and replicate that dataset in all the workspaces. These workspaces will use a subset of the centralized dataset. How do i do that?:

Q. Are the subset datasets simply pointers to the centralized dataset or are they replicated copies of the entire dataset?
Q, Can the individual datasets (the datasets used in different workspaces) be locked down as per the permissions?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Datasets in Workspace

@kin ,

 

I would suggest you to create new app workspace and assign the user as contributor. Please see doc below:

https://docs.microsoft.com/en-us/power-bi/service-new-workspaces#roles-in-the-new-workspaces

 

Capability Admin Member Contributor
Update and delete the workspace. X    
Add/remove people, including other admins. X    
Add members or others with lower permissions. X X  
Publish and update an app. X X  
Share an item or share an app. X X  
Allow others to reshare items. X X  
Create, edit, and delete content in the workspace. X X X
Publish reports to the workspace, delete content. X X X

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 REPLIES 4
Community Support Team
Community Support Team

Re: Datasets in Workspace

@kin ,

 

Centralized dataset is not existing in power bi service because same report in each workspace will have seperate dataset. 

 

If your requirement is to let members can only view specific contents, I would suggest you to create a dynamic RLS on the dataset in each workspace.

 

Third-party blogs Reference:

https://www.fourmoo.com/2018/02/20/dynamic-row-level-security-is-easy-with-active-directory-security...

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

kin Frequent Visitor
Frequent Visitor

Re: Datasets in Workspace

. Imagine a dataset as a table and we want to have that table be given access to certain workspaces. In terms of the reports, they will be out of our hands because others will create them, based on datasets to which they have access.
kin Frequent Visitor
Frequent Visitor

Re: Datasets in Workspace

. Imagine a dataset as a table and we want to have that table be given access to certain workspaces. In terms of the reports, they will be out of our hands because others will create them, based on datasets to which they have access.
Community Support Team
Community Support Team

Re: Datasets in Workspace

@kin ,

 

I would suggest you to create new app workspace and assign the user as contributor. Please see doc below:

https://docs.microsoft.com/en-us/power-bi/service-new-workspaces#roles-in-the-new-workspaces

 

Capability Admin Member Contributor
Update and delete the workspace. X    
Add/remove people, including other admins. X    
Add members or others with lower permissions. X X  
Publish and update an app. X X  
Share an item or share an app. X X  
Allow others to reshare items. X X  
Create, edit, and delete content in the workspace. X X X
Publish reports to the workspace, delete content. X X X

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 247 members 2,592 guests
Please welcome our newest community members: