Member-only story
The Ultimate Guide to Row-Level and Object-Level Security in Power BI
“Who sees what in the report?” is one of the key security questions in Power BI. Learn two possible ways to implement the access control
Congratulations! In the previous articles, you’ve learned how to design and build large format datasets, how aggregations can speed up your Power BI reports, and how to leverage composite models feature to get the maximum flexibility in designing enterprise-scale tabular models. Not just that, you’ve also discovered how DirectQuery works in Power BI, what are external tools, and how to extend your data modeling skills by creating calculation groups. Don’t forget some little DAX tricks with variables, virtual relationships, and iterators…
It’s time to wrap up by explaining how to secure your data — or maybe it’s better to say — how to control the access to certain portions of your Power BI solution. You can choose between Row-level-security (RLS) and Object-level-security (OLS). To be clear, it’s not that choosing one eliminates the possibility to use another — you can use both RLS and OLS within the same solution.
Let’s make a quick distinction between these two and in which scenarios would make sense to use RLS, OLS, or both. We’ll start with the…