Thanks to all attendees of my Power BI webinar last Friday. I hope you all enjoyed it. I explained a number of the most common row level security patterns in Power BI with some DAX expressions, in this post you will find the description of webinar, recording, and link to all demos and materials. Although the webinar was in Friday, as of right now it had 2000 views already. I hope sharing this content gives you a lot more insight about row level security in Power BI.
Unleash Security Patterns in Power BI
Security is different from Sharing, Sharing is about sharing the entire content with others, security is about authorizing different views of the content to others. In this session we go through many different Row Level Security patterns; Static Row Level Security, Dynamic Row Level Security, and many variations of the dynamic RLS, such as giving manager access as well as employee access, you will learn about user profile security scenarios, and hierarchical access levels. This session shows you how DAX and Power BI security comes together to play an important part of a Power BI project lifecycle: Row Level Security.
Video
Link to demos and blog posts
Power BI from Rookie to Rock Star book: FREE
https://radacad.com/online-book-power-bi-from-rookie-to-rockstar
Static Row Level Security
The logic of security is static in the role definition, we call it Static Row Level Security. to learn more about it, read this blog post.
Row Level Security in SSAS Live Connection
In this case, the Power BI Report connected live to an SSAS model. the username will pass through effective username connection information, to learn more about it, read this post.
Dynamic Row Level Security
When you have too many roles, then implementing static roles is not an option. You need to create one role and maintain the logic of security within the data model. This is called Dynamic row level security. To learn more about this, read this blog post.
Manager Level Access in Dynamic RLS
Sometimes you need the manager to have access to all data. This post explains how to do it.
Dynamic Row Level Security with Users and Profiles
When each user can be part of multiple profiles, or each profile can have many users. This many to many situation creates a different approach for row level security. This post explains in details how that method of security can be implemented.
Dynamic Row Level Security with Organizational Hierarchy
When each user needs to see their own data, and their manager to see data of people under his hierarchy. This post explains in details how that method of security can be implemented.
If you have any questions, please feel free to ask in the comments section.
Reza is author of more than 14 books on Microsoft Business Intelligence, most of these books are published under Power BI category. Among these are books such as Power BI DAX Simplified, Pro Power BI Architecture, Power BI from Rookie to Rock Star, Power Query books series, Row-Level Security in Power BI and etc.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer.
Reza’s passion is to help you find the best data solution, he is Data enthusiast.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog.