Forum Discussion
HELP Please: Show the Data But Not All the Details (Data Filtering Based on USERPRINCIPALNAME?)
Hello, I have a table that shows production and I would like all employees to see everyone's production but only see their own name (the rest of the names should be blank). This I have achieved usin...
lbendlin
Super User
Super UserYou need two copies of your fact table. One table is visible without names. You create measures for "Mine" and "Others". The other table is hidden and has the names. Use RLS to control access to the hidden table.
Thanks! Do you know how I would go about using RLS to access to access the hidden table? When I tried this, it still filtered the hidden the table and only showed me my data. I think it's because under Manage Roles, my table filter is [LogInEmail] = USERPRINCIPALNAME()? Do you know what I should use? I'm fairly new at Power BI & DAX... appreciate any help.
- lbendlin
This article may help you Managing hierarchical organizations in Power BI security roles - SQLBI