Forum Discussion
Alaahady
Advocate II
Advocate IIBest practice for sharing a semantic model across multiple Fabric workspaces without duplicating it
Hi Fabric Community, I’m looking for guidance on the recommended architecture for sharing centralized semantic models across multiple Microsoft Fabric workspaces. My current architecture is: DEV ...
v-sathmakuri
Community Support
Community SupportHi Alaahady ,
Thank you for reaching out to fabric community.
- Keep one centralized semantic model in the DEV workspace, avoid duplication.
- Grant departmental users Read permission on the semantic model without giving them access to the DEV workspace.
- Build permission is not required for users who only consume existing reports.
- Publish reports through departmental Fabric Apps and configure appropriate App audiences.
- Implement RLS/OLS to restrict data access by department.
- Test with departmental user accounts to verify report access and data security.
Thanks!!
AlaahadyAdvocate II
Advocate IIThank you for your comprehensive respond. I agreed with most of your points
I have 2 questions here:
- How to Grant departmental users Read permission on the semantic model without giving them access to the DEV workspace.
- Is there another option, I have thousands of users and granting access to more than 120 semantic model is a full-time job and I'm afraid of losing control and impact governance
- Alaahady
Thank you for your comprehensive respond. I agreed with most of your points
I have 2 questions here:
1. How to Grant departmental users Read permission on the semantic model without giving them access to the DEV workspace.
2. Is there another option, I have thousands of users and granting access to more than 120 semantic model is a full-time job and I'm afraid of losing control and impact governance