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
Justification Prompts When Downgrading or Removing Sensitivity Labels in Power BI Desktop
Description Currently, organizations can configure Microsoft Purview sensitivity label policies to require users to provide a justification when removing a label or lowering its classification. T...vvargasv12 hours agoMicrosoft EmployeeNew11Views0likes0CommentsVisual Type Defaults in Visualization Pane
This would change my life with fussy clients and client/public facing apps. In addition, it would allow me to add more value to the clients on retainers who do not have the 'hours' to allocate to...IolaWhiteley14 hours agoAdvocate IINew48Views7likes0CommentsMatrix: column totals as a bar chart docked to the edge
What's missing Data bars already work on the Total row and column through conditional formatting, so row totals can be read as length. Column totals cannot: they render as a horizontal bar inside a ...Sayurivalente14 hours agoRegular VisitorNew79Views6likes1CommentAllow Bookmarks to Affect Multiple Report Pages
Description: I would like to request the ability for a single Power BI bookmark to affect and maintain a state across multiple report pages, rather than being limited to a single page. For example,...Josegonzalez2114 hours agoNew MemberNew20Views4likes1CommentFeature Proposal: Expandable/Collapsible Page Sections for Reports on Same Semantic Model
Subject: Feature Proposal: Expandable/Collapsible Page Sections for Reports Using the Same Semantic Model Dear Microsoft Power BI Team, I would like to propose an enhancement to the Power BI report...Dr7awb14 hours agoNew MemberNew32Views1like1Comment