Row-Level Security - Sharing Dataset across multiple workspaces

[BMassey]

Hello!  I'm fairly new to Power BI.  I've done a lot of research but still hoping to connect some dots.  Here is the scenario:

I want to maintain a single dataset but have it leveraged across multiple workspaces.  I've already figured out how to accomplish this.

Dataset is published to Workspace A

Reports are published to Workspace A

App created from Workspace A

Users of this app should have full visibility to the data (no filtering)

Reports published to Workspace B, which uses dataset from Workspace A

Workspace B set-up in "view only" mode

App created from Workspace B

Users accessing this App should have row-level security applied so that they only see their data and/or data for those that report under them.

I've done a lot of research around row-level security and have done a proof-of-concept implementing it.  However, is the above scenario possible using a shared dataset or would I need to have two different datasets?

[Greg_Deckler · Accepted solution]

@BMassey Yes, you would configure 2 roles in the dataset, one for users of workspace A and one for users of workspace B. 

[BMassey]

Thanks @Greg_Deckler!  Appreciate the guidance.

[eerba2]

hi, were you able to set this up? i'm trying to accomplish the same. my user roles are based on their user ID. i have published a report to a second workspace like your example above, however, on the second workspace there is no security option to assign the role and/or preview as role.

[Silvano]

You would assign the roles on the shared dataset, which would be in the first workspace. The second workspace will only have the report, which uses the shared dataset sitting in the first workspace.