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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

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

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



Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

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



Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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