How to protect salary data

[GunnerJ]

My work is considering a project that would should employees their bonuses based on some metrics the individual was graded in. The hang up is who can see the salary portion behind the scenes making up that calculation. Is there anyway to where even the creaters of the content couldn't see the actual numbers? 

One idea was a static file only HR would have access to and that during the creation phase it could be dummy data. My thought was that if anything ever needed to be fixed it'd be visible at that point.

Open to any suggestion. 

[GilbertQ]

Hi @GunnerJ 

What you can do is to use Object Level Security, which I explain in my blog post on how to do this

Configure OLS in Power BI using Tabular Editor to limit access to non-financial measures - Reporting...

[GunnerJ]

@GilbertQ  Thank you for the reply. Will Object level security only impact end users? There's some concerns about even the content creator seeing the data. Is there anyway around the creator from seeing the actual data or is it neccessary?

[GilbertQ · Accepted solution]

Hi @GunnerJ 

The content creator of the dataset will always see all the data.

The only way a user cannot see the data is if they connect to an already created dataset. This is by design because a user creating a dataset should have access to all the data to be able to make sure what they are creating is correct.