Row Level Security in Power BI Desktop

Published Jul 01 2022 09:44 AM 1,207 Views
Microsoft

Picture1.png

 

 

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

 

 

Version history
Last update:
‎Jul 01 2022 07:56 AM
Updated by: