Forum Discussion

PBI_Member_01's avatar
PBI_Member_01
Helper III
2 years ago

Segregate single Power BI Dataset for different workspaces

Greetings Power BI Community ! I am looking for best possible ways to maintain a single unified dataset across multiple workspaces. For my case, I have a single Power BI Framework connected usi...
General Comment
Need Help
Show and Tell
Tips and Tricks
PBI_Member_01's avatar
PBI_Member_01
Helper III
2 years ago

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

TomMartens's avatar
TomMartens
Super User
2 years ago

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

Regards,

Tom

  • PBI_Member_01's avatar
    PBI_Member_01
    Helper III
    2 years ago

    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