How to display/hide visual(s) based on user login?

[Anonymous]

Hello,

we are maintaining a table where we do the mapping of which user sees which visual. We need to check and hide visuals which are not there in the list for particular user. 

For Eg.

UserNM	PageNM	VisualNM
User1	Page1	Visual1
User1	Page1	Visual2
User1	Page2	ViIsual3
User2	Page1	Visual2
User2	Page2	Visual3
User2	Page2	Visual4

This means, when user1 logins, he/she will be able to see Visual1 & Visual2 on Page1 whereas user2 will see only Visual2 on Page1 and so on .

Is this possible?

[v-zhangti]

Hi, @Anonymous 

You can try using RLS to achieve your results. Please refer to the following document, hope it can help you.

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

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

https://community.powerbi.com/t5/Desktop/Dynamic-RLS/m-p/2523328#M895590 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-zhangti  Thanks for the reply.

But we are not looking for RLS.

Using RLS, will make the data on the visual disappear but Actually we need to hide/show the entire visual.

 As shown in the above example, User1 will see only 1 visual whereas User2 will see 2 visuals.