Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 4 | |
| 3 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 3 |