Forum Discussion
dax filter help for role
I have a table with 3 records, I just want to apply a role which filters data only to username Joe (from table)
so i am giving below dax ...what is the error here and how to fix it. Please advise
- Anonymous6 years ago
Anonymous
You just need to add joe's power bi account to the RLS group.then share the report to him with share button OR add him to the workspace as a Viewer (other roles are not restricted by RLS).
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
5 Replies
- AnonymousNot applicable
ok, so the syntax is "joe"...able to create role
however, when I publish the report, how can I apply this role to the data ? I see all 3 records, my goal is to see just the row that has Joe
- Greg_Deckler
Community Champion
You need double quotes instead of single quote
[username] = "joe"- AnonymousNot applicable
yes that works, and in desktop, when i say view as "test-role", i get rows filtered accordingly (only see Joe info)
how to make this happen in the power bi service ? i mean i want to share this report to joe where he sees only joe's data in pbi service
- AnonymousNot applicable
Anonymous
You just need to add joe's power bi account to the RLS group.then share the report to him with share button OR add him to the workspace as a Viewer (other roles are not restricted by RLS).
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly