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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
nixonba2
Frequent Visitor

Impact & reversibility of disabling "Use semantic models across workspaces"

Hello,

After reading the documenation I still don't understand precisely what disabling "Use semantic models across workspaces" will do in my tenant, so I don't know how best to prepare. I know we want this disabled for information security reasons, but I want to ensure a smooth transition for the users. I considered briefly switching it off to run some tests then switch it back on, but I cannot establish if it is strongly reversible. My questions are:

  1. In general, does this setting only prevent the creation of new cross-workspace content, or does it block access to (or delete) existing reports in shared workspaces that are connected to semantic models in other workspaces?
  2. Does this setting apply to "My Workspace" workspaces in the same way as shared workspaces? That is, will it block access to (or delete) reports in users' "My Workspace" that are connected to semantic models in other workspaces?
  3. Does this setting override share links that grant users access to content in workspaces of which they are not a member?
  4. Is this setting strongly reversible or does turning it off remove content or permissions that would not be restored were it to be turned back on?

Thank you,

1 ACCEPTED SOLUTION
nandic
Memorable Member
Memorable Member

@nixonba2 i find this link much more useful: https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-across-workspaces

In general, if you want to have 1 central dataset and want to allow report creators from multiple teams to create reports based on that central datasets and publish them to different workspaces, you need to enable this option.

Otherwise, you would need to have the same dataset in multiple workspaces and each of them needs to be refreshed.

I haven't seen any issues with this option, i find sharing dataset across workspaces very useful for centralized reporting. 
Refresh is taking only once and if there are any changes, you make them only on central dataset.
Otherwise, you would need to fix same things on multiple datasets.

Cheers,
Nemanja Andic

View solution in original post

2 REPLIES 2
nixonba2
Frequent Visitor

Thank you for suggesting an alternate approach, @nandic. I read that document and spent much time considering that approach but unfortunately it does not work for my organization because we have some fields and tables that only certain user groups are allowed to see, but OLS and RLS only apply to the Viewer workspace role, and we want users to have build permissions in their respective workspaces. From what I understand, Power BI offers no way to permit a user to build reports against a dataset without permitting him access to every table and field in that dataset. I agree it is inconvenient to have to maintain several variations of a dataset! I find the best way is to do work on the most complete version, then have a documented procedure for deleting fields/tables to spawn the more restrictive variants.

 

@v-rzhou-msft can you please undo your marking of this topic as solved? I am still hoping for answers to my 4 questions.

nandic
Memorable Member
Memorable Member

@nixonba2 i find this link much more useful: https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-across-workspaces

In general, if you want to have 1 central dataset and want to allow report creators from multiple teams to create reports based on that central datasets and publish them to different workspaces, you need to enable this option.

Otherwise, you would need to have the same dataset in multiple workspaces and each of them needs to be refreshed.

I haven't seen any issues with this option, i find sharing dataset across workspaces very useful for centralized reporting. 
Refresh is taking only once and if there are any changes, you make them only on central dataset.
Otherwise, you would need to fix same things on multiple datasets.

Cheers,
Nemanja Andic

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors