Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
BMassey
Frequent Visitor

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?

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Thanks @Greg_Deckler!  Appreciate the guidance.

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.

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.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors