Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
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.
@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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
105 | |
105 | |
88 | |
61 |
User | Count |
---|---|
165 | |
133 | |
132 | |
95 | |
86 |