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.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Revival of report hiding feature in New App UI
The previous App UI, we can hide report pages in app settings, and we can use cross report drill-through with the target reports hidden. This was a great way to build a simple app. But in contrast t...hyaman9114 minutes agoMicrosoft EmployeeNeeds Votes624Views39likes8CommentsAllow hiding non-functional JSON file links in Fabric Data Agent responses
**Description** Fabric Data Agent automatically displays generated JSON file references (e.g., `result_4.json`) alongside query results, even when the user asks a simple question that returns a sing...sh_130971 hour agoNew MemberNew4Views0likes0CommentsRemove the "ownership" and "take over ownership" features for Fabric items
Remove the "ownership" and "take over ownership" features for Fabric items in workspaces. The workspace roles should be the only determinant of who can do what with any Fabric item, following the pri...mike_honey4 hours agoMemorable MemberNew5Views0likes0CommentsAuto Y axis labels and gridlines to be above max value
The operation of the auto y axis labels and gridlines frequently results in charts where the max value is above the maximum visible y axis value. For eg. line charts like the below, where much of the...nicS19816 hours agoNew MemberNew4Views0likes0Comments