dax filter help for role

[Anonymous]

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 

[Greg_Deckler]

You need double quotes instead of single quote

[username] = "joe"

[Anonymous]

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 

[V-pazhen-msft · Accepted solution]

@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

[Anonymous]

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

[amitchandak]

@Anonymous , refer if this can help

https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns-in-Power/td-p/712613

https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/