Pro Power BI Architecture: Sharing, Security, and Deployment Options for Microsoft Power BI Solutions

© Reza Rad 2018

Reza RadPro Power BI Architecturehttps://doi.org/10.1007/978-1-4842-4015-1_18

18. Patterns for Dynamic Row-Level Security

Reza Rad¹ 

(1)

Meadowbank, Auckland, New Zealand

 

This chapter is an addition to the previous chapter. We will talk about some of the patterns of Dynamic row-level security, such as Dynamic row-level security with Manager-Level Access, Users and Profiles with Dynamic row-level security, and Organizational Hierarchy access in the Dynamic row-level security.

Manager-Level Access

“What If I want users to see their data, and the Manager to see everything?,” or “How do I add Manager- or Director-Level access to the dynamic row-level security?” This section will answer this question. In this chapter, you will learn a scenario ...