Blog Post

Educator Developer Blog
1 MIN READ

Row Level Security in Power BI Desktop

theoyinbooke's avatar
theoyinbooke
Icon for Microsoft rankMicrosoft
Jul 01, 2022

 

 

The Same KPIs, Different Department

 

Scenario: You have different managers requesting to see the same KPIs (Customer Count, Revenue Generated, Products Performance, etc) for their different region. Data privacy requires that the various managers only see reports for their regions. A simple way to think about this is by creating different reports for the managers making a total of 3 Reports. 

 

I am sure you will agree with me that this isn't effective. more efforts and it is not scalable. what if it is a large multinational - country manager, regional manager, group manager, unit head, team leads all across the world? will you also build different reports for over 500 people? With Row Level Security, you can easily address this challenge by building a single Reports and set roles and rules to filter what everyone can see.

 

 

Learn and Practice Along here:

 

 

 

Additional Resources

 

 

Updated Jul 01, 2022
Version 1.0
No CommentsBe the first to comment