Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
Thank you,
Solved! Go to Solution.
@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
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.
@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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
52 | |
35 | |
32 | |
30 | |
25 |