Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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?
Solved! Go to Solution.
@Anonymous Yes, you would configure 2 roles in the dataset, one for users of workspace A and one for users of workspace B.
@Anonymous Yes, you would configure 2 roles in the dataset, one for users of workspace A and one for users of workspace B.
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.
User | Count |
---|---|
46 | |
26 | |
21 | |
19 | |
18 |
User | Count |
---|---|
51 | |
46 | |
24 | |
21 | |
20 |