Showing results for 
Search instead for 
Did you mean: 
New Member

Row Level Security and Aggregate View

I have created row level securty so that each employee can view their own performance numbers but not able to view other employees' numbers.  However, I'd like each employee to be able to view their own performance, as well at the aggregation of all the emplyees in the company's performance, as way of benchmarking themselves to the complany average employee.  Is there a way to give permission so an emplyee can see their own numbers and the aggregate company's numbers?

Super User IX
Super User IX

Re: Row Level Security and Aggregate View

There can be a better way, But by creating an aggregated table or by having a dummy employee having aggregated data and all employees have access

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Community Support
Community Support

Re: Row Level Security and Aggregate View

HI @dmarti44,

I'd like to suggest you create a summarized table on query editor side without relationship key to user mapping table. (remove sensitive fields) Then your users can view tables with their own data and summarized table records.


Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors