This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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?
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |