Forum Discussion
Segregate single Power BI Dataset for different workspaces
Hey PBI_Member_01
you can achieve what you are looking for by using a 3rd workspace that only holds semantic model. Content creators who are publishing content reports (reports that hold the data visualizations) do not need to have a role assigned to this data workspace. The content creators do not connect to the underlying data source, instead the content creators are connecting to the Power BI dataset from inside Power BI Desktop.
The only thing content creators need is the build permission to the sematic model. This approach will give you:
- a single semantic model (a shared model)
- content creators can create their own reports with RLS honored
Hopefully, this provides what you are looking for to tackle your challenge.
Regards,
Tom
Hi TomMartens
Thank you for your suggestion.
I understand the approach you are taking but we only have two workspaces to work with and having a separate workspace for maintaining the datasets does not adhere with the organization's architecture. Something that is not in my control.
Currently, there is also RLS applied which gives access to users according to their specific roles and can only see their own hierarchy of data within the organization.
While keeping that intact, any other possible approach that you may suggest for this problem.
Best Regards
Hey PBI_Member_01 ,
not considering a separate workspace for the semantic model is wrong as sometimes this is essential. I never heard of a "there are only two workspaces available" architecture. From my perspective the organization errs.
I recommend reading
- the Power BI Guidance documentation: Power BI guidance documentation - Power BI | Microsoft Learn
Regards,
Tom
Hey TomMartens
Thank you once again for your recommendation.
For clarity, What I meant by two workspaces was currently the organization either have Product Category or department specific workspaces set up and do not follow with maintaining the semantic models separately. I did suggest this approach at the beginning but unfortunately, did not get a green light on this. I will try to pitch this idea to the higher management again and see where it takes us.
Also, just to touch back on this approach, like I've mentioned that Workspace W1 is dedicated to only Product Category 'A' and Workspace W2 is dedicated to Product Category 'B' and 'C', even if I have a single unified semantic model, since I want both my contributors and viewers to see only the data specific to their workspace (i:e W1 only Category 'A' regardless of their role and W2 with Category 'B' and 'C'). Using this approach, I will be controlling the Data accessibility through RLS for all my userbase, correct?
Thanks for all the help so far.
Best Regards