How to limit user to see his/her own data

[bpw320]

 when sharing a powerBI dashboard/report within an organization, how to allow users only see their own data?

for example, I have a sales table:

user  product  amount

a        p1          12.0

a        p2          13.0

b        p1           24

b       p2            23

I want to only allow user a to see first 2 rows (his own data)

[Anonymous · Accepted solution]

Sounds to me like Row Level Security is what you want to set up:

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/