Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Row-Level Security - Sharing Dataset across multiple workspaces

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?

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

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

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

      • eerba2's avatar
        eerba2
        Frequent Visitor

        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.