We released a new course for our SQLBI+ subscribers: Security in Tabular Semantic Models. This course explains how to implement security in Tabular semantic models, considering different requirements, data model design, DAX implementation, and performance.
The training is reference material for developers creating a security infrastructure using Tabular semantic models for Power BI, Microsoft Fabric, and Analysis Services. After briefly reviewing the features available for securing a semantic model, we provide several practical examples that showcase common patterns in enterprise solutions.
The course includes over 4.5 hours of videos and a white paper in PDF format that should be used as companion content. The white paper does not replace the video content: we did not describe most user interface interactions for designing and testing security roles in writing, as video is more effective.
While most examples utilize Power BI Desktop for educational purposes, the techniques presented apply to semantic models published on the Power BI service, Fabric, or Analysis Services.
Compared to the security-related content in the Mastering Tabular and Optimizing DAX courses, this SQLBI+ course adds more practical examples and focuses on best practices for implementing the optimal solution depending on your requirements. If you are entirely new to semantic models, consider learning the basics in Mastering Tabular before starting this course in SQLBI+. For more advanced considerations about performance, you will find those along with measurement techniques in Optimizing DAX.
Stay tuned for new SQLBI+ content coming later in 2025!