Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I have a table that displays employee data, some of which is sensitive. We want to hide the employee name for users who don't have the proper security. I already have the following datasources. I am just not sure how to link them together to get the results I want.
| Employee Data: | ||
| Name | Salary | PayGroup |
| Jane Doe | 20000 | 1 |
| John Doe | 15000 | 2 |
| Jim Smith | 10000 | 3 |
| Joe Shmoe | 5000 | 4 |
| Tom Thumb | 25000 | 1 |
| Current User Name: |
| UserName |
| =USERNAME() |
| User Security Info: | |
| Username | PayGroup |
| mydomain\Donald | 1 |
| mydomain\Donald | 2 |
I have 2 users in my example - Donald and Nancy. When they view the report, the table should look like so:
| User Donald should see: | |
| Employee Name | Salary |
| Jane Doe | 20,000 |
| John Doe | 15,000 |
| Tom Thumb | 25,000 |
| ***** | 15,000 |
| User Nancy should see: | |
| Employee Name | Salary |
| ***** | 75,000 |
Any ideas?
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |