Forum Discussion
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_DecklerCommunity Champion
Anonymous Yes, you would configure 2 roles in the dataset, one for users of workspace A and one for users of workspace B.
- AnonymousNot applicable
Thanks Greg_Deckler! Appreciate the guidance.
- eerba2Frequent 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.