Unlock the secrets to creating and sharing shared semantic models in Power BI, especially for enterprise-grade environments. This video covers critical aspects of row-level security (RLS), object-level security (OLS), and strategies to empower your report writers. Whether you’re building scalable data models or ensuring secure data access, this guide is your key to success.
💡 What You’ll Learn:
- Effective sharing strategies for semantic models.
- Role assignment best practices for RLS and OLS on shared semantic models.
- Required settings on Microsoft Fabric Admin Portal.
- Tips to empower report writers in your organisation.
🌐 Related blogs:
✅ Microsoft Fabric: Unlocking the Secrets to Mastering Shared Semantic Models – Part 1 – Core Concepts: https://biinsight.com/microsoft-fabric-unlocking-the-secrets-to-mastering-shared-semantic-models-part-1-core-concepts/
✅ Microsoft Fabric: Unlocking the Secrets to Mastering Shared Semantic Models – Part 2 – Implementation: https://biinsight.com/microsoft-fabric-unlocking-the-secrets-to-mastering-shared-semantic-models-part-2-implementation/
📙 Purchase my book, "Expert Data Modeling with Power BI, 2nd Edition" from here: https://amzn.to/437WI1L
🌐 Visit my blog: https://biinsight.com/
✅ Follow me on LinkedIn: www.linkedin.com/in/bakhshi
✅ X (Twitter): https://x.com/_SoheilBakhshi
🔗 Links:
➡️ Understanding Roles in Fabric Workspaces: https://learn.microsoft.com/en-us/fabric/get-started/roles-workspaces?WT.mc_id=DP-MVP-5003466
➡️ Understanding semantic model permissions: https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-permissions?WT.mc_id=DP-MVP-5003466
➡️ Understanding Semantic model permissions and row-level security (RLS): https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-permissions?WT.mc_id=DP-MVP-5003466#semantic-model-permissions-and-row-level-security-rls
Chapters:
00:00 - Channel trailer
00:21 - Introduction
02:11 - Key Concepts of Shared Semantic Models
03:09 - Solution Diagram
06:57 - Sharing Semantic Models
08:35 - Why Report Writers Cannot Access the Shared Semantic Models
09:32 - Necessary Setups in Fabric Admin Portal
10:16 - Creating Thin Reports from Shared Semantic Models
11:13 - View Item Lineage
11:42 - Grant Build Permission on Shared Semantic Models
13:06 - Why Users do not have Access to the Shared Semantic Models containing RLS or OLS
14:03 - Assigning Users to RLS and OLS Roles in Semantic Models
15:19 - Testing the User Assignment to RLS and OLS Roles
16:36 - Wrap up
Song: Moth
Music by: CreatorMix.com