Grzegorz Strzyminski on 26 Nov 2024 22:52:12
A great add over Row-Level Security could be Page-Level Security: granting some access to report pages selectively to some users.
Currently possible workarounds include either bookmarks/page navigation/conditional formatting (making the font transparent) and can be quite easily worked around by savvy users (by drillthroughs, sharing the link to a given report page directly etc).
I propose an approach and framework that is more robust and user friendly. Current demo of the solution relies on a combination of a user-page mapping table, RLS, page-level filters and a calculation group. This is possible to implement already in Power BI as outlined in tutorial: https://www.youtube.com/watch?v=g7_Yt4u8tBk&t=2s
This could be made even more user friendly and intuitive if the idea would make it to the development roadmap of Power BI.
Parts of the current framework for PLS could likely be reused / be an inspiration / have an UI put over them to make them more user friendly:
- assigning roles/users to an automatic list of pages,
- choosing the behaviour of what happens when a user goes into a page they don't have access to - blank out all the visuals, return errors etc. Currently this is handled by a calculation group.