Filter data to have specific user to see

[yuhkao]

Hi 

Can I have filtered data from report and have certain user to see this limited data, not whole data?

not sure power bi is able to feature like this or not.

thanks 

best

[amitchandak · Accepted solution]

@yuhkao , refer RLS

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies

[Anonymous · Accepted solution]

HI @yuhkao,

I'd like to suggest setting RLS on your username filed and use relationships to link and filter other tables. (it required a user mapping table that used to map user id and user account)

RLS with UserName() 

After you publish to power bi service, you can create a security group to assign RLS role to enabled RLS filter. (notice: please confirm these users only have read permission or they will ignore RLS filter effects)

Row-level security (RLS) with Power BI 

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@yuhkao , refer RLS

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies