The Secrets to Mastering Shared Semantic Models in Power BI and Microsoft Fabric

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-fabri...
✅ Microsoft Fabric: Unlocking the Secrets to Mastering Shared Semantic Models – Part 2 – Implementation: https://biinsight.com/microsoft-fabri...

📙 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/fab...

➡️ Understanding semantic model permissions: https://learn.microsoft.com/en-us/pow...

➡️ Understanding Semantic model permissions and row-level security (RLS): https://learn.microsoft.com/en-us/pow...

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